Assuming the numbers are always positive...

Try one of these:

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

This one is an array formula** :

=AVERAGE(IF(A1:A100,A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"tommy" wrote in message
...
Hi, I have a column with a line of numbers and I have set an average at
the
bottom using Autosum but it is dividing the zeros as well is there any way
around this?.

Thanks in advance, Barry.