Excel Table Formula

[Hitman Hotrods]

Good afternoon, I have made a table where the rows list each item in an assembly and the columns list assemblies. So Column 1 will be Items, Column 2 cost per item and each remaining column will have an assembly number. In Row 1 I want to total the cost of each assembly and each remain row will list the individual Items. The values under each assembly will represent how many of each Item are required per assembly. I would like the cell in row 1 under each assembly to look up each value in a column and multiply it by the cost in the same row and sum all of them together. There are 48 rows but each assembly may only use 15 Items.

See Sample Attachment

Thanks in advance.

Scott

[alansidman]

Please read the banner at the top of this thread about uploading a worksheet.

[Hitman Hotrods]

I think so. Lets see how this goes.

[Fluff13]

How about, in D2 copied right
=SUMPRODUCT($C$3:$C$10,D3:D10)

[Ghozi Alkatiri]

try this one
at D2
=SUMPRODUCT($C$3:$C$10,D3:D10)

copy cross and down