Need a formula to count

[vinu]

Hello Frnds,


I have a data like this: columnA -Data & column B- range & column c- Data in Range(Need formula for this), Please help me a formula to get the answer in column C.


A B C( Need a formula to count the col A data tat falls in B Col range)


25 0-100 2

150 101-200

250 201-300

350 301-400

475 401-500

75 0-100

600 like this..

550


Thanks is advance!!

 

[Hui]

Vinu

=+SUMPRODUCT(1*($B$1:$B$6=B1))

and copy down

Make sure all the Col B cells have a value in Col A

 

[vinu]

Thanks a lot Hui.