I would like to count the total number of "1"s and "2"s across a range of
(b8:cu30000). I have an autofilter set up and I would only like to count the
exposed rows. I would like to exclude the rows hidden by the autofilter.
When I use the countif function, it includes the hidden rows. Any help would
be appreciated.

Thanks
Drew