Subtotal past errors

[Steven]

This array works nice:

=SUM(IF(NOT(ISERROR(E1:E4)),E1:E4))

But what if you want a SUBTOTAL?

Thank you,

Steven

 

[Peo Sjoblom]

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