C
coastal
I would like to calculate the average of a range but want to ignore any cells
equal to zero. I tried the following formula but it returns an error
messsage (#NAME?)
=AVERAGEIF(O2:O1092,">0")
Does anyone have another formula? I am using Excel 2003
equal to zero. I tried the following formula but it returns an error
messsage (#NAME?)
=AVERAGEIF(O2:O1092,">0")
Does anyone have another formula? I am using Excel 2003