View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Subtotal Countif

Is there an option to countif( ) those cells
after being filter as above?


It can be done. What column do you want to perform the "countif" on and
what's the criteria?


--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
If I have a filter on column "A..G" and then I filter on ecolumn for x
criteria... I do subtotal (9,A5:A200) it will only add up those meetting
the
filter criteria...

Is there an option to countif( ) those cells after being filter as above?