| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal
How do I get a subtotal when the data I am Subtotaling contains #n/a without
returning an answer of #n/a. I am using =SUBTOTAL(9,M6:M199)/SUBTOTAL(9,P6:P199)/1440 This formula takes total time in seconds divided by total calls divided by 1440 and the cell is formated to time. The answer should return a time in minutes and seconds; however, it returns #n/a. How would I get the formula to ignore the #n/a in the data set that it is calculating? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
