Help with CountIf Formula

I need a count of # of rows based on data in 2 different columns. All data is on the same reference sheet.

Here is the formula I have written that keeps coming back as unparseable:

=COUNTIF({Global Talent Mobility Intake Range 1}, OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"),AND ({Global Talent Mobility Intake Range 2}, "Operations")))

I receive an accurate count for: COUNTIF({Global Talent Mobility Intake Range 1}, OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"), and I receive an accurate count for: =COUNTIF({Global Talent Mobility Intake Range 2}, "Operations"). I receive an error when I try to combine the 2 together.

What I am trying to count is...if Status is "New", "On Deck", or "Backlog" AND Team is "Operations", show me the total #.

Any suggestions? Thanks!

Find more posts tagged with

Formulas

Accepted answers

Dale Murphy

@jpoulo Try the COUNTIFS function

=COUNTIFS([Column7]:[Column7], OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"), [Column8]:[Column8], ="Operations")

... works for me. Just replace column 7 with your external ref Range 1, column8 with your Range 2.

All comments

Dale Murphy

@jpoulo Try the COUNTIFS function

=COUNTIFS([Column7]:[Column7], OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"), [Column8]:[Column8], ="Operations")

... works for me. Just replace column 7 with your external ref Range 1, column8 with your Range 2.

jpoulo

@Dale Murphy - Thank you for the help! That worked!

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.