Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions |