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!

Tags:

Best Answer

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Answer ✓

    @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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!