Help with Lookup/Sum Formula

[Adam X]

I have a spreedsheet with this type of data, for example

Product Group Quantity Size
2812 10 0.75
2812 100 0.75
2812 300 0.5
2817 100 0.25
2817 200 1
2845 1000 1.5


I want to be able to set up a formula that you enter a product grou
(2812) in a cell and it will for that product group go and sum up al
the quantities for each size. The formula would go in the Sum colum
For Example

2812

Size Sum
0.375 2,342
0.5 2,342
0.75 1,992
1 883
1.25 284
1.5 90
2 290
2.5 16
3 32
3.5 0
4 26

So far i have had no luck with figuring out a formula that wil
accomplish all this, any help would be appreciated.

Thank

 

[bill k]

I have used your numbers and set them out in a table A1 to C6


I then set up a table with the possible sizes in the left han
column(A12 down)
and the possible product groups in the column headers in B11 an
across

entered in B12

=SUMPRODUCT(--($C$1:$C$6=$A12),--($A$1:$A$6=B$11),$B$1:$B$6)

note the $ signs especialy for $A12 and B$11

this makes it possible to extend the formula down the columns an
across

good luc