How do I count multiple types in a column?

This is my current formula that works:

=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {QUARTER}, HAS(@cell, "Q1'23"))

But now, I need the formula to count multiple quarters (see the last part of the equation). I need it to pull Q1'23, Q2'23, Q3'23, Q4'23. How do I add those on? ...

Thank you!

Find more posts tagged with

Formulas

Accepted answers

Ryan Sides

Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or...

=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {Quarters}, OR(HAS(@cell, "Q1'23"), HAS(@cell, "Q2'23"), HAS(@cell, "Q3'23"), HAS(@cell, "Q4'23")))

Is your Quarters column a multi select dropdown? If so, the above will work. If it isn't, let me know.

@A Rose your suggestion would work, but it would add the requirement of all quarters to exist in the row before that row would be counted.

All comments

A. Rose

Hi @nicoleejordannn,

Can you add after: {QUARTER}, HAS(@cell, "Q1'23"), {QUARTER}, HAS(@cell, "Q2'23") etc. ?

Thank you,

Ryan Sides

Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or...

=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {Quarters}, OR(HAS(@cell, "Q1'23"), HAS(@cell, "Q2'23"), HAS(@cell, "Q3'23"), HAS(@cell, "Q4'23")))

Is your Quarters column a multi select dropdown? If so, the above will work. If it isn't, let me know.

@A Rose your suggestion would work, but it would add the requirement of all quarters to exist in the row before that row would be counted.

nicoleejordannn

@Ryan Sides I didn't have the quarters in the dropdown but added it and it worked perfectly. Thank you so much!

Ryan Sides

@nicoleejordannn Glad to hear it!

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.