"Average" Help!!

Posted by George on November 07, 2001 3:14 AM

Hi everyone,

Would someone know how to calculate the average of column but only including in the average cells with a value of 1 or higher, in other words, if the cell has a value of 0 or text it will not be included in the average.

Thanks

Posted by Aladin Akyurek on November 07, 2001 4:02 AM

Re:

George,

Let A1:A6 house the data of interest.

=SUMIF(A1:A6,">0")/MAX(1,COUNTIF(A1:A6,">0"))

will give you the kind of average you want.

Aladin

=================