Hi faizzsheikh
So you want to count how many time John has a value between 1-10,try one of the following and assuming the data is in A1:B11
For Excel 2007: =COUNTIFS(B1:B11,"John",A1:A11,"=1",A1:A11,"<=10" )
For Excel 2003<: =SUMPRODUCT((B1:B11="John")*(A1:A11=1)*(A1:A11<=1 0))
Or a Pivot table
Kevin
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
|