Multi Select Column Stacked Bar Graph Formula

Hello,

I am having trouble finding the correct formula to add a specific combination of multiselect selections that are entered in a row. For example, I want to count all instances of options a & b in a column. Also, in the same formula reference the status.

Below is the formula we are using to count this with one selection, but how do we add multiple selections?

=COUNTIFS($Department1:Department19, "Downstream CAM", $Status1:Status19, "Not Started")

Thanks!

Find more posts tagged with

Accepted answers

All comments

manley85am

Try adding an OR statement in your COUNTIFS function. Below is an example if you wanted to find all not started, as well as started.

=COUNTIFS($Department1:Department19, "Downstream CAM", $Status1:Status19, OR(@cell = "Not Started", @cell = "Started"))

LaMonya

Thanks! That worked! If I want to add Upstream CAM + Downstream CAM as a department selection, would I still use OR or another function to count them both? I tried, but I may have entered it incorrectly.

Thanks!

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.