View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
 
Posts: 181
Default Subtotal Countif

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?