hi everbody
ı have a problem below given

For example
A B C
45 T 100
56 Y 200
78 T 300
89 U 250
95 Y 500
120 T 158
145 U 800

excell should take reference counts at B columns by calculating between
REPEAT NUMBERS
ı gave a sample below

Y 2 times repated(It should take Y's)
95*56
U 2 times repated((It should take Y's)
89*145

how can ı solve my problem
Excel stops when it see first solution as vlookup,match;ındex;find etc..

Briefly How can ı take more than one critteria in excel ???

thankss