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

"Luke M" wrote:

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),"")

---
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"--Viewpoint" wrote:

Can someone provide a formula for the following:

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