Averageif Error

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

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
 
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
 
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")
 
Back
Top