countifs referencing another sheet


I want to insert a formula in one sheet that references a column in another sheet where is counts if the symbol is Yellow, green or red. I can get it to count for yellow but unsure how to add green and red.


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Edit Kalb In that case you have two options. You can count all three together or you can count everything that is not blue.

    All three together:

    =COUNTIFS({Sheet Reference}, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))

    Everything except for blue:

    =COUNTIFS({Sheet Reference}, @cell <> "Blue")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!