How do I run a filter then have my countif change?
 

I have a spreadsheet that I have set up to auto filter. It also performs the
countif function on specific columns. How do I get the countif to change
based on changing the filtered data. Right now it shows the totals for all
data and I want it to only count for the filtered data.