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 omittedancillary hardware:
=COUNTIF({Project Impact Analysis (OctDec 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 (OctDec 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 (OctDec 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 (OctDec 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 (OctDec 2020) Range 4}, CONTAINS("Omitted Ancillary Hardware")>0)
Help Article Resources
Categories
Check out the Formula Handbook template!