What formula is needed to count specific catagories from a drop down (multi Select)
Hi!
I am hoping that someone has come across this and can offer a little insight on how I can do this.
I have a sheet with a drop down column that has multi select.
I want to count each time one of these selections is used and graph it.
The problem I am running into is that the formula I am using does not seem to count when there is an entry with multi selections.
This is the formula that I am using for counting omitted-ancillary hardware:
=COUNTIF({Project Impact Analysis (Oct-Dec 2020) Range 4}, "Omitted- Ancillary Hardware")
The formula works fine when it sees omitted- ancillary hardware only and will count it but if in this example there is a cell that has omitted- ancillary hardware and omitted- required labor it will not count either one.
I do have a column setup to count each selection with the appropriate formula to match but when there is multi select they do not get counted.
Any help would be appreciated.
Thank you!
Best Answers
-
Yep, sorry. CONTAINS contains 2 parameters. What to search for and where to search for it (my bad). The formula should say:
=COUNTIF({Project Impact Analysis (Oct-Dec 2020) Range 4}, CONTAINS("Omitted- Ancillary Hardware", @cell))
-
You are awesome!!!
Thank you very much that worked like a charm.
Answers
-
Just wrap the item you're looking for in CONTAINS(). That will check to see if the cell contains that item at all.
=COUNTIF({Project Impact Analysis (Oct-Dec 2020) Range 4}, CONTAINS("Omitted- Ancillary Hardware"))
-
Thank you David. When I use contains I get an "#INCORRECT ARGUMENT SET" error message.
-
Yep, sorry. CONTAINS contains 2 parameters. What to search for and where to search for it (my bad). The formula should say:
=COUNTIF({Project Impact Analysis (Oct-Dec 2020) Range 4}, CONTAINS("Omitted- Ancillary Hardware", @cell))
-
You are awesome!!!
Thank you very much that worked like a charm.
-
Try:
=COUNTIF({Project Impact Analysis (Oct-Dec 2020) Range 4}, CONTAINS("Omitted- Ancillary Hardware")>0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!