# Help with CountIf Formula

Options
✭✭

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!

Tags:

• ✭✭✭✭✭✭
Options

@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

• ✭✭✭✭✭✭
Options

@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

• ✭✭
edited 02/23/22
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!