OR, try this:

=SUM(A1:A10)/COUNTIF(A1:A10,"0")

Assumes *no* negatives.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
My bad !

See Dave's formula.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
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.