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
|