Help with Lookup/Sum Formula
 

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 group
(2812) in a cell and it will for that product group go and sum up all
the quantities for each size. The formula would go in the Sum column
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 will
accomplish all this, any help would be appreciated.

Thanks


--
Adam X
------------------------------------------------------------------------
Adam X's Profile: http://www.excelforum.com/member.php...o&userid=27562
View this thread: http://www.excelforum.com/showthread...hreadid=470869

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 hand
column(A12 down)
and the possible product groups in the column headers in B11 and
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 and
across

good luck


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=470869