Maybe I need a if/then statement

[JBG]

I have row D that needs to be over 4.00% to be counted 33%
Row H that needs to be a positive number to be counted 33%
Row L that needs to be a positive number to be counted 33%
and the sum of all three rows add in row P. The range could be 0%, 33%,
66%, or 100% I hope this makes since.

 

[JBG]

I also did not want to create any rows that contained any information other
than row P.

 

[Pete_UK]

You are getting rows and columns mixed up - columns are referred to by
letter. Assuming you want to start this on row 2, then try this in P2:

=(D2>0.04)/3 + (H2>0)/3 + (L2>0)/3

Format the cell as percentage, then copy down as required.

Hope this helps.

Pete