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