Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average with error
I'm trying to complete an average for time.
The problem is I'm doing this over a 12month period so the months where there is no data I'm getting the #DIV\0! in each month i have a time colum at the bottom of each i have a monthly average colum where i want to get the average time for the month... this is the formula that i am using: =IF(AVERAGE(F6:F36)=iserror,"n/a",AVERAGE(F6:F36)) I'm still getting the #DIV\0! error which in turns causes my YTD average to be the same. I appreciate your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE around a #Div/0 error? | Excel Discussion (Misc queries) | |||
Average Error | Excel Worksheet Functions | |||
AVERAGE function returns #DIV/0! error | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
"Average" with error DIV/0 | Excel Discussion (Misc queries) |