not including 0's

[maksud]

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

 

[Mangesh Yadav]

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

Mangesh

 

[Bob Phillips]

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)

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

Mangesh