| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal ignoring Error Values
Hi,
I'm searching for a subtotal formula, which can ignore errors. For regular sums I use a formula like this: "{=SUM(IF(ISNUMBER (Data),Data))}, which excludes errors. Does anyone have an idea how I can apply this to a subtotal operation? Regards Werner Exclel XP SP3 Win XP SP3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I require a macro to complete ignoring the following error | Excel Discussion (Misc queries) | |||
| Sum ignoring cells with error | Excel Worksheet Functions | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| Ignoring error values in a formula | Excel Worksheet Functions | |||
| Something similar to sum() but ignoring error value arguments! | Excel Worksheet Functions | |||
Threaded Mode
