What if I dont' want the error sign if all my #'s are 0. The formula worked
great for me too, but sometimes on a weekend when we don't run a line, there
are 0's for each shift. When this happens, I get the error #DIC/0!...
--
Thank you for your time!
John


"T. Valko" wrote:

If you are going to use the last suggestion it would be safer to use
SUM(A1:A10)/COUNTIF(A1:A10,"<0")

If the numbers are always positive how is that safer? It's actually less
safe than using 0.

The COUNTIF will include text, empty cells, and Booleans.


--
Biff
Microsoft Excel MVP


"ShaneDevenshire" wrote in
message ...
Hi,

If you are going to use the last suggestion it would be safer to use
SUM(A1:A10)/COUNTIF(A1:A10,"<0")

Alternatively in 2007 you should consider this:

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

In all versions you could also use

=AVERAGE(IF(A1:A10<0,A1:A10,""))

This formula is array entered (press Shift+Ctrl+Enter to enter it rather
than Enter)


--
Thanks,
Shane Devenshire


"tommy" wrote:

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.