Hello -

I have 4 symbol (Red, Green) columns (Named: Step 1, Step 2, Step 3, Step 4). I am wanting to count the rows where Step 1 is Green and Step 2 is Red.

I came up with this formula, but for some reason it is not working. Any ideas why?


=COUNTIFS([Step 1]:[Step 1], "Green"), [Step 2]:[Step 2], "Red")

Best Answer

  • Kelly Drake
    Kelly Drake Overachievers Alumni
    Answer ✓

    Take out the parenthesis after "Green".

    =COUNTIFS([Step 1]:[Step 1], "Green", [Step 2]:[Step 2], "Red")

    Kelly Drake (she/her/hers)

    STARBUCKS COFFEE COMPANY| business optimization product manager


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!