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
-
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
Answers
-
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
-
REALLY GOOD! That worked like a charm. Thank you so, so much!
-
Happy to help.
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!