Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averageif Error
I am using the formula
averageif($G219:$N219,"<0") in my workbook however if one of the cells contains "0" it returns the error #DIV/0! Why and how can I get rid of it Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averageif Error
In excel 2007 the below works if atleast there is one entry which is not = 0
=AVERAGEIF($G219:$N219,"<0") If you mean to avoid div error if all the cell values are 0 then try the below =IF(SUM($G219:$N219),AVERAGEIF($G219:$N219,"<0"), "") If this post helps click Yes --------------- Jacob Skaria "Curtis" wrote: I am using the formula averageif($G219:$N219,"<0") in my workbook however if one of the cells contains "0" it returns the error #DIV/0! Why and how can I get rid of it Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averageif Error
Actually, you're getting the error if there are no cells that are non-zero,
right? If the range is always numeric, then you could use: =if(countif($g219:$n219,"<0")=0,"no numbers",your formula here) Or you could check to see if the only numbers were 0's: =IF(COUNT($G219:$N219)=COUNTIF($G219:$N219,0),"no numbers","your formula here") Curtis wrote: I am using the formula averageif($G219:$N219,"<0") in my workbook however if one of the cells contains "0" it returns the error #DIV/0! Why and how can I get rid of it Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGEIF | Excel Worksheet Functions | |||
Help with Averageif Formula (don't think I should use Averageif) | Excel Discussion (Misc queries) | |||
AverageIF | Excel Discussion (Misc queries) | |||
averageif | Excel Worksheet Functions | |||
averageif | Excel Discussion (Misc queries) |