Average If

[--Viewpoint]

Can someone provide a formula for the following:

If cells A1:A10 are greater than 0
Then Average A1:A10
Else (leave cell blank)

 

[Luke M]

Do you mean if each cell is greater than 0, include in average, or just if
the sum of numbers is greater than 0, average them?
Former:
=SUMIF(A1:A10,">0")/COUNTIF(A1:A10,">0")
Latter
=IF(SUM(A1:A10)>0,AVERAGE(A1:A10),"")

 

[John]

Hi
Try this =IF(COUNTA(A1:A10)>0,AVERAGE(A1:A10),"")
HTH
John

 

[--Viewpoint]

Thank you, the =IF(SUM(A1:A10)>0,AVERAGE(A1:A10),"") formula is the one I
need.