Count of request Status for each System using COUNTIFS statement with OR criteria

Hi,

I have a sheet with a list of requests for various Systems and am trying to create metrics for how many "Active" requests exist for each System. I'm able to get these to work:

Count of rows by "Active" Statuses: =COUNTIF({Sheet Range 2}, OR(@cell = "0 - Submitted", @cell = "2 - Approved"))

Count of rows by System: =COUNTIF({Sheet Range 6}, CONTAINS("SYSTEM A", @cell))

I tried using this to combine the two but get a #UNPARSEABLE error: =COUNTIFS({Sheet Range 2}, OR(@cell = "0 - Submitted", @cell = "2 - Approved"), ({Sheet Range 6}, @cell = "SYSTEM A"))

Find more posts tagged with

Accepted answers

Erin Aten

Thanks, David, good catch! It's the simple things, right? Here's what seems to have worked:

=COUNTIFS({Sheet Range 6}, @cell = "SYSTEM A", {Sheet Range 2}, OR(@cell = "0 - Submitted", @cell = "2 - Approved"))

All comments

David Tutwiler

I think you have an extra ( before your Sheet Range that is causing issues. Try:

=COUNTIFS({Sheet Range 2}, OR(@cell = "0 - Submitted", @cell = "2 - Approved"), {Sheet Range 6}, @cell = "SYSTEM A")

Erin Aten

Thanks, David, good catch! It's the simple things, right? Here's what seems to have worked:

=COUNTIFS({Sheet Range 6}, @cell = "SYSTEM A", {Sheet Range 2}, OR(@cell = "0 - Submitted", @cell = "2 - Approved"))

David Tutwiler

Glad to see it's working.

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.