hi
I have long sheet sheet which have many colour with size and CTN is No of
carton
I want to summary of each colour wise, size wise total qty.

A B C D E F
COLOUR <----SIZE------- TOTAL CTN
S M L
RED 10 10 10 30 5
150 TOTAL QTY
BLACK 5 5 5 15 2
30 TOTAL QTY
RED 10 10 10 30 3
150 TOTAL QTY

I am using this formula =SUMIF($A$3:$A$5,"RED",$B$3:$B$5) ITS GIVE 20 which
is right. but i wnts its multiply by CTN column like 10*5 +10*3=80

anybody please help me how its possible. please urgent...

Thanks
RKS