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.