Try this:

=SUMPRODUCT((A1:A6=2)*(B1:B6=1))

Hope this helps.

Pete

On Nov 27, 9:25*am, 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?