Count visible autofilter results

I can do a countifs to get the number of cells matching a string.
I can filter on a different column and the countifs doesn't change.
I would like to autofilter on a second column and have the countifs show the count on the visible cells only.

Essentially it is a personnel file and I am looking at jobs. I would like to filter on status (Active, Terminated, On Leave, etc) and the countifs of adjacent (not in the table) two cells tell me how many of the visible cells are "Trainee" or "Tech". I know I could just apply all three autofilters and then note the results. But, I am not the only one using this spreadsheet and the other person is kind of phobic.

I thought I had a lead using the subtotal function. But I just can't seem to make it work.

Originally Posted by GeoffW283

Sorry, not so easy after all

This may help though.

Attachment 687594

Col-A contains the list. Cell D2 contains the value that the col-A list is to be matched against.

Col-B is the filter. In the above picture rows 5 and 6 are filtered out (A5 contains "bb")

E9 contains the count of visible col-A rows that match "bb" = 2 In E9:

Formula:

Please Login or Register  to view this content.

Workbook is attached.

Hopefully you can adapt this to your needs.

Thank you very much. That will work. I had an epiphany while driving home today. I rebuilt the countifs to include a row height greater than 0 as one of the criteria. That also works. I am going to put both solutions onto the workiing sheet to see if various tasks interferes with one but not the other....