Hi,
I am struggling here, and have spend hours to lookup formula to do the calculation with no luck. I have a table looks like following:


COLOR S M L XL
NAVY 297 297 198 0
PURPLE 297 297 198
PINK 297 297 198
BLACK 297 297 198
NAVY 96 96 64
PINK 81 81 54
PURPLE 57 57 38
NAVY 100 102 25
PURPLE 75 26
PINK 106 10
BLACK 68 27

-----------------------------------------------
And I need to make a summary table looks like
Size Color Total Qty
S Navy 493
S Black
S Pink
S Purple


Can some one tell me whats the formula to put in Total Qty that will automatically lookup and sum the number in the table. Right now I have to calculate total by hand. Any help is grateful.