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

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