What formula is needed to count specific catagories from a drop down (multi Select)



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!