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
|