Subtotal past errors

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

This array works nice:

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

But what if you want a SUBTOTAL?

Thank you,

Steven
 
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
 
Back
Top