The following array formula will exclude zeros from the
AVERAGE.of the numbers in A1:A10.

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

Since this is an array formula, you must press CTRL+SHIFT+ENTER
rather than just ENTER when you first enter the formula and
whenever you edit it later. If you do this properly, Excel will
display the formula enclosed in curly braces {} in the formula
bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Luna Saisho" wrote in
message
...
Hiya!

I've been tasked to fix a spreadsheet that has a few issues.
I've fixed
most of what I need, but I have a problem I'm wondering if
anyone has a
solution to. :)

Basically, it needs to find an average of a rather tall column
of times.
The problem is that until a truck has come to pick up the load,
the times are
all 0:00, and from what I know, it's averaging those zeros.
Does anyone know
how to adapt the averaging forumula (which is currently
=AVERAGE(O38:O167))
to forget about the zero'd times?

Thanks!!
Steph