Thread: Subtotal ignoring Error Values
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Werner Rohrmoser Werner Rohrmoser is offline
external usenet poster
  
Posts: 88
Default Subtotal ignoring Error Values
Thank you xlmate,
I modified your formula like this (see at the end ",0,1"):
=SUM(IF(ISNUMBER(Data),Data)*(SUBTOTAL(3,OFFSET(Da ta,ROW(Data)-MIN(ROW
(Data*)),0,1))))
and now it works perfect.

Werner
Reply With QuoteReply With Quote