Quote:
Originally Posted by faizzsheikh
I want to count the numbers between 1 to 10 from the range for a particular person as seen in the below example.
Keyword Rank__________Person Name
1_____________John
5_____________Agnes
8_____________Agnes
12____________John
20____________Agnes
13____________Agnes
3_____________John
40____________John
8_____________John
15____________Agnes
10____________John
I want to count the the numbers that John has between 1 to 10 only. In the above case John must have 4 Keyword Ran between 1 to 10
Please help!
Thanks in advance
Faiz
|
Hi Faiz,
Assuming your example data covers cells A1:B12 with the headers in row 1, you can use
=SUMPRODUCT((B2:B12="John")*(A2:A12=1)*(A2:A12<=1 0)) in any version of Excel or
=COUNTIFS(B2:B12,"John",A2:A12,"=1",A2:A12,"<=10" ) in Excel 2007 or later.