Look at SUBTOTAL

PC

"Justin Sadowski" <Justin wrote in
message ...
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