Stuck on a formula for a multi-drop down

Hi everyone,

I'm using sheet summary to count various formulas for me and I'm stuck on the below. I need to count all rows that have "Strategy" in the Channel column, whether it's the only entry or one of several.

I've tried variations using HAS or CONTAINS but it still doesn't work.

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, "Strategy")

Thanks in advance!

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, HAS(@cell, "Strategy"))

All comments

Paul Newcome

Try this:

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, HAS(@cell, "Strategy"))

K Ops

That's worked! Thanks so much Paul

Paul Newcome

Happy to help. 👍️

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.