Could you consider Autofilter follow by Subtotal.
This will ignore the error value.

Does this help? pls click yes if this help

cheers

"Werner Rohrmoser" wrote:

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