If your numbers are in A1:A10 then an array formula will do it in all Excel
versions.

=AVERAGE(IF(A1:A10<0,A1:A10)) enter this with Ctrl+Shift+Enter not just
Enter

Excel 2007

=AVERAGEIF(A1:A10,"<0")


"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.