On Nov 27, 4: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?

I use an arrary formula:

={SUM(IF(A2:A7=1,1,0)*IF(B2:B7=2,1,0))}

Create an array formula

When you enter an array formula (array formula: A formula that
performs multiple calculations on one or more sets of values, and then
returns either a single result or multiple results. Array formulas are
enclosed between braces { } and are entered by pressing CTRL+SHIFT
+ENTER.), Microsoft Excel automatically inserts the formula between
{ } (braces).