Thanks I understand the formula but what if I just wanted the N - how many
level 2 responded to the question or in this case received a rating
(regardess of the rating score?)?

-S

"RonaldoOneNil" wrote:

Assuming your data is in columns A and B

=SUMPRODUCT((A2:A7=2)*(B2:B7=2))

"stephanie" wrote:

HI. I've tried several different ways now to the experts :)

I have two rows of data:
Emp Lvl Rating
1 4
2 3
2 2
1 4
1 2
2 3

I need to count How many emp lvl 2's with rating 2 = 1

what is the formula for this?