COUNT IF Question.

[NAZQAR]

In column A the numbers 1, 2 or 3 may appear. In Column B there will be a Yes or a No. I want to be able to count how many 1's, 2's or 3's there are which is easy enough but I also want to know how many of each number have a Yes in their corresponding row in column B.

 

[Burrgogi]

You're on the right track. Since you're evaluating more than 1 criteria, you need to use COUNTIFS; not COUNTIF. This formula will count total number of cells with a value of 1 (with "Yes" in col. B)
=COUNTIFS(A:A, "1", B:B, "Yes")

 

[NAZQAR]

You're on the right track. Since you're evaluating more than 1 criteria, you need to use COUNTIFS; not COUNTIF. This formula will count total number of cells with a value of 1 (with "Yes" in col. B)
=COUNTIFS(A:A, "1", B:B, "Yes")

Yeah, I figured it out after thinking for a bit. I have been "away" from Excel for a few years so I am a bit rusty. Thank you.