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!!