Counting how many cells have any of some multiple options in them per column
Hi everyone.....
I'm so close but so far.
I want a formula that sums how many times each cell has any of several options in them.
My pseudo-code: Look at all the cells in a column. If a column's cell has A, B, or C in it or any combo of A,B or C, count it as 1. Count all the cells and tell me how many cells have either A, B, or C in them.
I currently have something that will count if the cell only has one of the possible options, but not if the cell has multiple of the possible options:
=COUNTIF([column:column, OR(@cell = "MS4 Task sent", @cell = "MS4 Mid way point chase", @cell = "MS4 Response received", @cell = "MS6 Task sent", @cell = "MS6 Mid way point chase", @cell = "MS6 Response received"))
If more than one of those options are in the cell, it doesn't count anymore. Should it be AND? Some kind of AND/OR combo?
Thanks folks!
Sarah
Answers
-
You only need to incorporate the HAS function.
=COUNTIFS(Column:Column, OR(HAS(@cell, "A"), HAS(@cell, "B"), HAS(@cell, "C")))
-
Again, so close...I was trying out HAS but hasn't been able to make it work.
It works, thank you!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 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!