Counting Multiple Symbols
Hello!
I have tried COUNTIF and COUNTIFS trying to get the count of "Yellow" and "Red" symbols. I'm using Green, Yellow, and Red.
Is there a formula that will populate the total of the Yellow and Red within a single column?
Answers
-
Hi @Aimee Eckert ,
Try this, where [column name] is in place of your column name:
=COUNTIF([column name]:[column row], OR(@cell="Red", @cell="Yellow"))
You could also do it separately:
=COUNTIF([column name]:[column row], "Red") + COUNTIF([column name]:[column row], "Yellow")
Hope this helps! Let me know if it works.
Best,
Heather
-
I used =COUNTIF([column name]:[column row], OR(@cell="Red", @cell="Yellow"))
It worked perfectly! Thank you so much!
-
@Aimee Eckert Fantastic! Happy to help. Have a great weekend.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!