Hi,

the first solution jumping to my mind would be one of the two: -
1- either you use advanced filter and copy data to a new sheet where you can
analyse it

or

2- better use Pivot Tables.

Will any of these do?

Khaldoun
Specialized Technologies
Saudi Arabia


--
Khldoun
Specialized Technologies
Saudi Arabia


"Dr Happy" wrote:

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?