I have reviewed other questions regarding this subject, but didn't see anything that helped pertaining to my situation.

I have a table in which I will filter ambulance runs by month. The table has various data about the specific call and the amount charged.

I also have 3 columns to specify which EMT went on the run. At the end of each month I'd like to have a tally of how many runs each EMT went on.

It's set up like such( there are other columns in between amount and balance that I didn't put in this scenario:

Date Run # Name Amount Balance EMT1 EMT2 EMT3
1/1/11 2 Doe, Jane $200 $200 Sue John Bill
2/1/11 3 Deer, Joe $200 $0 Ron Sue John

So at the end of January I can filter for just the January runs, and on the right of the table I have a list of EMT's. I'd like to have beside them a calcualtion of the number of runs they took in that month. Like:

EMT #of Runs
Sue (would like calculated based on the 3 columns in table)
John
Ron
Bill

Obviously the Countif function counts all the runs regardless of the filter. If there is a way to set this up simpler that I'm not seeing, I'm open to those suggestions.

Thanks in advance for your help.