Counting with conditions based on another range
Try this:
=COUNTIF(A:A,2)
or perhaps this:
=SUMPRODUCT((A1:A100=2)*(B1:B100<""))
Hope this helps.
Pete
On Nov 30, 8:40*am, stephanie
wrote:
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?- Hide quoted text -
- Show quoted text -
|