I have auto filter on for a set of row headers and would like to populate a
cell with the number of rows that match the filter selection. If my row
entries in this column are "Yes" and "No", for example, I'd like to show the
number of "Yes" entries in the column when I filter by "Yes" or "No" when
filtered by "No".

A pivot table is over kill for my solution.

Thanks in advance!!