Since the auto filter cannot reference an outside cell to set the criteria,
and outside functions cannot read the criteria you have set in the auto
filter, this would require a vba function work-around. I have done this
before. (Vba can set the criteria of autofilter)

I just tested the advanced filter function. It does reference outside cells
for criteria, so you can use it in conjunction with countif or sumif type
functions (which also can use the content of outside cells as criteria) to do
what you want, but the advanced filter is cumbersome, it requires multiple
clicks every time you change the criteria. (It doesn't change automatically
when you change the contents of the criteria cells.) So you would still be
looking at some coding to automate that function, just to make it useful.

Are you up to some vba coding?

SongBear

"Justin Sadowski" wrote:

I have a spreadsheet that contains an attendance list of courses over the
last 5 years offered through a healthcare facility. I am applying a filter
that filters by course title, date, and status (pass, fail, cancel...). Is
there a way of setting up a count function to count each cell that contains
the text "pass?" Then I want the formula to be applied to each subsequent
filter. How can I do this?

Thank you