COUNTIFS ASSISTANCE
I want to count the number of "training" for Elter Wilson on 3/6/24. What would the COUNTIF statement look like? Also what if I had a 4th criteria of Pass? I am creating a results report so need to reference this other sheet.
Best Answer
-
Hey @Jen_Gray
I see you marked Paul's response as not answering your question. He's correct that a COUNTIFS with an S is the way to go! The link above has examples of how to built it out.
This is an example formula in your case:
=COUNTIFS({Training Column}, "Training", {Representative Column}, "Elter Wilson", {Date Column}, DATE(2024, 03, 06))
Keep in mind each {range} is one you will need to manually create by finding the correct column to reference as you build the formula. See: Cross-sheet formulas
On a side note, it may be easier to create a Report to get this data. Your Report filter would be each of your criteria (Training & Date) and then you could GROUP by the Representative and use the SUMMARY feature to count how many rows appear in that sheet. Reports with one level of Grouping and Summary can be used for charts. Here's a free webinar with more information: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
You would use a COUNTIFS with the "S" on the end to have multiple range/criteria sets.
There are some samples at the bottom of this article:
-
Hey @Jen_Gray
I see you marked Paul's response as not answering your question. He's correct that a COUNTIFS with an S is the way to go! The link above has examples of how to built it out.
This is an example formula in your case:
=COUNTIFS({Training Column}, "Training", {Representative Column}, "Elter Wilson", {Date Column}, DATE(2024, 03, 06))
Keep in mind each {range} is one you will need to manually create by finding the correct column to reference as you build the formula. See: Cross-sheet formulas
On a side note, it may be easier to create a Report to get this data. Your Report filter would be each of your criteria (Training & Date) and then you could GROUP by the Representative and use the SUMMARY feature to count how many rows appear in that sheet. Reports with one level of Grouping and Summary can be used for charts. Here's a free webinar with more information: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!