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?