Perhaps this will work:

=SUMIF(J114:J164,"0",J114:J164)/COUNTIF(J114:J164,"0")

HTH,
Elkar


"C.S.Harris" wrote:

I have a sheet that shows when an item was logged out (i.e. maintenence) and
when it was logged back in. The sheet calculates how long each item was
logged out. Now I want to calculate the average outage time for all items
listed.
I have tried the following functions, the first one errors becase of zero
values, the second one is supposed to ignore zero values, but it just doesn't
work.
=AVERAGE(J114:J164)
=AVERAGE(J114:J164)+IF(J114:J164<0,"","")

Anything will help!!