can someone help my formula

[sitelbanat]

=COUNTIF(O69:O82,">0", IF(O69:O82,">0",(E69:E82 *1),0),0)


IF O range >0 then Multiply that cell count by the same row in E range.
for example if

O range

O69=2356
O72=5625
O74=5625
O76=5642

E range

E69=.80
E72=.60
E74=0
E76=0

the answer should be 4.4 for O85 that's where the formula belongs

 

[Andrew Poulsom]

How about?

=SUMPRODUCT(--(O69:O82>0),--(E69:E82>0))+SUMIF(E69:E82,">0")

which will count the cells in O69:O82 that are greater than zero if the corresponding cell in column E is greater than zero, and add the sum of the greater than zero cells in E69:E82.

It would be helpful if you posted a less ambiguous data sample, without the same number of zero and non zero values in column E, and a detailed explanation of the expected result.

 

[NBVC]

Or...

=COUNTIF(O69:O82,">0")-COUNTIF(E69:E82,">0")+(SUMIF(O69:O82,">0",E69:E76))

 

[texasalynn]

So it looks to me the answer would be 3.4?

=(COUNTIF(O69:O82,">0")-COUNTIF(E69:E82,">0"))+(SUMIF(O69:O82,">0",E69:E82))

what did you finally decide on?