Try this"

=Sum(A1:A100)/Countif(A1:A100,"<0")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"markmcd" wrote in message
...
Could someone please advise me a nice simple formula for giving an average
for non zero entries. The average function in Excel provides an average of
a
list of numbers including numbers that are zero. I need the average of
just a
series of numbers where zeros are not considered in the result.