Hi,

Am Mon, 13 May 2013 08:07:41 +0100 schrieb 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

try:
=COUNTIFS(C2:C12,"John",B2:B12,"<=10")
for xl2007 or later
else try:
=SUMPRODUCT(--(C2:C12="John"),--(B2:B12<=10))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2