CountIf for a Multi-Select List
Good Afternoon,
I am building out an executive dashboard to support our SME Team and I am looking to count the number of times a specific value appears in a multi-select column. I am getting Unparsable errors with every attempt, any suggestion would be helpful.
This is my formula - =COUNTIFS(SME - Feature Progress Range 3,CONTAINS("Asset TL", @cell)))
Best Answer
-
Hello @SherieC
It appears you have a cross sheet reference however it is not bracketed properly. Did you type the reference in or did you insert it from the Reference Another Sheet link? If you inserted it properly, the curly brackets should be present.
=COUNTIFS({SME - Feature Progress Range 3},CONTAINS("Asset TL", @cell))
If you didn't use the Insert Reference link, you will need to do so.
Also, in your screenshot above, the colored parentheses are indicating you have an extra parenthesis at the end of the formula. Note the last parenthesis is black, not blue. An ending blue parenthesis typically indicates you have the correct number of parentheses in the formula.
You mentioned that you have a multi select column, however, I only see single select answers present. Single select and multi select refer to the number of responses possible in a single cell. If you have a list of possible responses in a dropdown list but only allow one response per cell, that is a single select dropdown - regardless of how many choices you had to choose from. Is this what you meant?
If your column is single select you wouldn't need the contains function
COUNTIFS({SME - Feature Progress Range 3}, @cell="Asset TL")
Kelly
Answers
-
Hello @SherieC
It appears you have a cross sheet reference however it is not bracketed properly. Did you type the reference in or did you insert it from the Reference Another Sheet link? If you inserted it properly, the curly brackets should be present.
=COUNTIFS({SME - Feature Progress Range 3},CONTAINS("Asset TL", @cell))
If you didn't use the Insert Reference link, you will need to do so.
Also, in your screenshot above, the colored parentheses are indicating you have an extra parenthesis at the end of the formula. Note the last parenthesis is black, not blue. An ending blue parenthesis typically indicates you have the correct number of parentheses in the formula.
You mentioned that you have a multi select column, however, I only see single select answers present. Single select and multi select refer to the number of responses possible in a single cell. If you have a list of possible responses in a dropdown list but only allow one response per cell, that is a single select dropdown - regardless of how many choices you had to choose from. Is this what you meant?
If your column is single select you wouldn't need the contains function
COUNTIFS({SME - Feature Progress Range 3}, @cell="Asset TL")
Kelly
-
Hi Kelly - It was a bracketing issue, thank you for the help on this one!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!