Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal past errors
This array works nice:
=SUM(IF(NOT(ISERROR(E1:E4)),E1:E4)) But what if you want a SUBTOTAL? Thank you, Steven |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal past errors
Why don't you try to avoid the error instead?
=SUM(IF(ISNUMBER($A$4:$A$27),$A$4:$A$27)*(SUBTOTAL (3,OFFSET($A$4,ROW($A$4:$A$27)-MIN(ROW($A$4:$A$27)),,)))) array entered btw, I would recommend to use SUM(IF(ISNUMBER(E1:E4),E1:E4)) instead of NOT(ISERROR -- Regards, Peo Sjoblom "Steven" wrote in message ... This array works nice: =SUM(IF(NOT(ISERROR(E1:E4)),E1:E4)) But what if you want a SUBTOTAL? Thank you, Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTOTAL ERRORS - PLEASE HELP ASAP | Excel Discussion (Misc queries) | |||
Subtotal position errors | Excel Worksheet Functions | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
subtotal nesting errors new this month | Excel Worksheet Functions | |||
Subtotal excl errors | Excel Worksheet Functions |