Help with Countif / Countifs formula

I am trying to count values from a column that is a dropdown/allow multiples column. For example, there are three dropdown options to choose from - red, green, blue. Cells will have one or more dropdown items selected. I need to count all cells that have red selected (regardless of the other choices). THat is, the number of times red is selected with or without the other colours. Can anyone help with writing the formula with the correct syntax? thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

J Tech

Hi Lorraine,

If you are creating the formula in the sheet summary, you can use the below formula

=COUNTIF(Colour:Colour, HAS(@cell, "Red"))

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.