Thanks for Quick Reply

Could you please tell me what is F2 in this Function

"Don Guillett" wrote:

This will do it for 1:4 where col c has the zones and col D has the numbers.
Copy down
=SUMPRODUCT(($C$2:$C$100=F2)*($D$2:$D$100=1)*($D$ 2:$D$100<5))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Hardeep_kanwar" wrote in message
...
HI! Expert
I have data in Two Column Like This:
Zone No.
East 4
East 8
East 6
East 31
East 5
East 9
East 3
East 9
North 1
North 5
North 9
North 7
North 2
North 6
North 10
North 5
North 10
South 2
South 6
South 10
South 8
South 3
South 7
South 1
South 4
West 3
West 7
West 5
West 9
West 4
West 8
West 2
West 8
Now i Want the total number based on Zone But i different Way

Like This: 1to4,5to7,8to10

Zone East has Number from 1to 10 or Sometime 1to7or8

Now i want a count of number Between 1 to 4 like In my Example:

Zone 1-4 5-7 8-10
North 2 4 3
East 2 2 4
South 4 2 2
West 3 2 3

i.e. how many times numbers 1 to 4 have appear in East Zone or any other
Zone. And also 5to 7 and 8to 10.

I hope you guys will understand my Problem.

Thanks in Advance

Hardeep kanwar