Average If
 

Can someone provide a formula for the following:

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

Average If
 

=AVERAGE(IF(A1:A100,A1:A10,"")) entered as an array formula (Control Shift
Enter).
--
David Biddulph

"--Viewpoint" wrote in message
...
Can someone provide a formula for the following:

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

Average If
 

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)

Average If
 

Hi
Try this =IF(COUNTA(A1:A10)0,AVERAGE(A1:A10),"")
HTH
John
"--Viewpoint" wrote in message
...
Can someone provide a formula for the following:

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

Average If
 

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)