not including 0's

maksud · Aug 9, 2005

how do you not include 0's when working out averages in a huge set o
dat

Mangesh Yadav · Aug 9, 2005

Enter the formula:
=AVERAGE(IF(A1:A100=0,"",A1:A100))
press control shift enter

Mangesh

Bob Phillips · Aug 9, 2005

Don't even need the other result

=AVERAGE(IF(A1:A100<>0,A1:A100))

--

HTH

RP
(remove nothere from the email address if mailing direct)

Mangesh Yadav said:
Enter the formula:
=AVERAGE(IF(A1:A100=0,"",A1:A100))
press control shift enter

Mangesh