HELP! I've been trying to get an error corrected on a workbook since last week to no avail. I have a large workbook with a separate worksheet for each day of the month, then a "totals" worksheet at the end. Everything is fine EXCEPT for the cells that require averages.
My workbook is used in a hospital to calculate the time it takes to transport patients from point a to point b. On each daily worksheet, a dispatcher logs each patient transport and we get a total transport time for that run. At the bottom of that worksheet, I need to average the times for that day. On the "totals" worksheet, I need to get a monthly average, using the daily averages for each day.
For each daily worksheet, the formula I used to calculate the average for the day is =AVERAGEIF(X2:X309,"<>0"). This will calculate as long as there is data in at least one of the fields, but if all of them are 0, I get the #DIV/0 error.
For the monthly average, I'm using the formula =AVERAGEIF('1:31'!W310,">0"). This comes up with a #VALUE! error.
Does anyone have any suggestions to help with these errors and to get rid of these error messages?
My workbook is used in a hospital to calculate the time it takes to transport patients from point a to point b. On each daily worksheet, a dispatcher logs each patient transport and we get a total transport time for that run. At the bottom of that worksheet, I need to average the times for that day. On the "totals" worksheet, I need to get a monthly average, using the daily averages for each day.
For each daily worksheet, the formula I used to calculate the average for the day is =AVERAGEIF(X2:X309,"<>0"). This will calculate as long as there is data in at least one of the fields, but if all of them are 0, I get the #DIV/0 error.
For the monthly average, I'm using the formula =AVERAGEIF('1:31'!W310,">0"). This comes up with a #VALUE! error.
Does anyone have any suggestions to help with these errors and to get rid of these error messages?