B
BurghRocks
Hello,
My worksheet is fairly simple. I am trying to calculate average time per
call between two sites. So for Monday, Site 1 would have 00:04:00 for 4
minutes in cell B2, Site 2 would have 00:03:30 for 3:30 (3 minutes 30
seconds) in cell B3. Cell B4 simply calculates the average of the two sites
for that day using the AVERAGE function.
The difficulty is when I am trying to then total the averages of the daily
totals, so for cell B4, then B8, B12, B16, and B20 (for Monday through Friday
averages) totalling to cell B24. If I only have data for Monday in cell B4,
I get an error in B24 because the other cells have the #DIV/0 error. I've
searched the boards and the closest array I can find for this is
=IF(ISERROR(AVERAGE(B4,B8,B12,B16,B20)),"",AVERAGE(B4,B8,B12,B16,B20)) to
place in the B24 cell. This returns a blank cell though.
Could the problem be the formula used or the custom cell format? I'm using
the mm:ss format for the cell.
I appreciate any help.
Thanks
My worksheet is fairly simple. I am trying to calculate average time per
call between two sites. So for Monday, Site 1 would have 00:04:00 for 4
minutes in cell B2, Site 2 would have 00:03:30 for 3:30 (3 minutes 30
seconds) in cell B3. Cell B4 simply calculates the average of the two sites
for that day using the AVERAGE function.
The difficulty is when I am trying to then total the averages of the daily
totals, so for cell B4, then B8, B12, B16, and B20 (for Monday through Friday
averages) totalling to cell B24. If I only have data for Monday in cell B4,
I get an error in B24 because the other cells have the #DIV/0 error. I've
searched the boards and the closest array I can find for this is
=IF(ISERROR(AVERAGE(B4,B8,B12,B16,B20)),"",AVERAGE(B4,B8,B12,B16,B20)) to
place in the B24 cell. This returns a blank cell though.
Could the problem be the formula used or the custom cell format? I'm using
the mm:ss format for the cell.
I appreciate any help.
Thanks