Help with CountIf Formula

jpoulo

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!

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.

dm

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.

dm

jpoulo

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