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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!