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" wrote in message
...
Enter the formula:
=AVERAGE(IF(A1:A100=0,"",A1:A100))
press control shift enter

Mangesh


"maksud" wrote in
message ...

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


--
maksud
------------------------------------------------------------------------
maksud's Profile:
http://www.excelforum.com/member.php...o&userid=26083
View this thread:
http://www.excelforum.com/showthread...hreadid=394150