COUNTIFS ?

Question

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?

Thanks!!!

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

Kelly Drake · Accepted Answer

Take out the parenthesis after "Green".

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