CountIfs Function for Daily Counts

Freddy Bustillos

I'm trying to get a count of records on a summary sheet, referencing another sheet that match multiple criteria by date, for multiple days. For example: I'd  like get a count for all matching criteria for 03/18/2020, and then a separate count for all matching criteria for 03/19/2020, etc.

This is formula I'm using, but I just need to add the portion that will CountIfs by individual date:

=COUNTIFS({EMPLOYEE AGENCY}, OR(@cell = "Fire", @cell = "Lifeguard", @cell = "Non-Sworn"), {EMPLOYEE RISK LEVEL}, "Low") 

Any idea how to accomplish this?  

Debbie Sawyer

If you are able to put these COUNTIFS in the sheet itself then I would add a column called DateforCount (or something) and fill the column with the earliest date you want to count from then drag down to populate with all dates from there on. These will act as headings for the COUNTIF solutions and also as part of the Criterion for the COUNTIF function. Then just add this new date as part of your function from above:

=COUNTIFS({EMPLOYEE AGENCY}, OR(@cell = "Fire", @cell = "Lifeguard", @cell = "Non-Sworn"), {EMPLOYEE RISK LEVEL}, "Low",{DateforCount},[DateforCount]@row)

Any good?

Kind regards

Debbie

Debbie Sawyer

If you are able to put these COUNTIFS in the sheet itself then I would add a column called DateforCount (or something) and fill the column with the earliest date you want to count from then drag down to populate with all dates from there on. These will act as headings for the COUNTIF solutions and also as part of the Criterion for the COUNTIF function. Then just add this new date as part of your function from above:

=COUNTIFS({EMPLOYEE AGENCY}, OR(@cell = "Fire", @cell = "Lifeguard", @cell = "Non-Sworn"), {EMPLOYEE RISK LEVEL}, "Low",{DateforCount},[DateforCount]@row)

Any good?

Kind regards

Debbie

Freddy Bustillos

REALLY GOOD! That worked like a charm. Thank you so, so much!

Debbie Sawyer

Happy to help.

Kind regards

Debbie