| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I ignore or hide the #N/A when doing a sum or subtotal?
Which hides all errors, not just #N/A
It is better to trap the error at the source rather than deal with it later. See Toppers' reply. Gord Dibben MS Excel MVP On 21 Mar 2007 13:24:47 -0700, "PWK" wrote: I had the same problem. You need to use ISERROR in your formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide an item subtotal in the row field? | 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 | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
