Using the COUNTIF with a wildcard but ONLY count visible rows

Hello,

I have a table of data and I am trying to return results using a wildcard. For example one column contains a few options (Stage 4 - MQL, Stage 2 - MPL, Stage 3 - MQL, etc). I'm using COUNTIF and wildcards to return a total of how many stage 2's I have, stage 3's, etc. The formula works great until I start filtering. It still counts the filtered rows and I would like to count just the visible rows. Is there an easy way to do this? My original formula that works great but returns visible and non visible results is =COUNTIF(H8:H1994, "*2*") This would give me a value of how many "Stage 2 - MPL" I had.

I thought maybe something like this would work =SUBTOTAL(3, H8:H1994, "*2*") would work the same but only return back visible results but I can't get it to work any way I format it. I've tried using an AGGREGATE function too in a similar way.

Any help would be great! Thanks!

Evan