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!

Find more posts tagged with

Accepted answers

David Tutwiler

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))

James P Garcia

You are awesome!!!

Thank you very much that worked like a charm.

All comments

David Tutwiler

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"))

James P Garcia

Thank you David. When I use contains I get an "#INCORRECT ARGUMENT SET" error message.

David Tutwiler

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))

James P Garcia

You are awesome!!!

Thank you very much that worked like a charm.

David Tutwiler

Try:

=COUNTIF({Project Impact Analysis (Oct-Dec 2020) Range 4}, CONTAINS("Omitted- Ancillary Hardware")>0)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.