CountIfs Function for Daily Counts


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?  

Best Answer


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

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    Happy to help.

    Kind regards


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!