You are either going not far enough, or too far. If you want to ue Filters and SUBTOTAL, then you
need to completely filter your data to get your count, along with your additional criteria from
COUNTIF - that is the equivalent of using COUNTIF. So apply another level or two of filtering.

Or don't use filters at all, and use pivot tables, hiding what you don't need.

Or - use horribly complicated SUMPRODUCT Formulas.

HTH,
Bernie
MS Excel MVP


"Dr Happy" <Dr wrote in message
...
I have created a worksheet consisting of columns consisting of name, work
group ( a 2 digit alpha numeric), gender and then some numerical data. I want
to autofilter on work group and then perform analysis on only the visible
rows left. Obviously I only want 1 summary row at the bottom which will
change as I apply different criteria to the auto filter (by selecting
different work groups). I can get count functions to work with sub-total but
I need to use the countif function. Any clues?