Multiplocation

**tonnyfm** · 11-24-2013, 04:14 PM

Hello. I am trying to multiply some weights for ex:
Item 1 Item 2 Item 3
8 10 15
8 14 22
14 10 17
8 8 8
2 5 8
with a list of prices

Item Item 1 Item 2 Item 3
Weight in kg 3.2 2.6 2.8

And get the sum of multiplication in a single cell with weight of shipment. I want a formula that I can easily implement. My idea was using
=SUM(D4*MASTER_Data_1!B4)+(E4*MASTER_Data_1!C4)+(F4*MASTER_Data_1!D4) but the problem is that I have a very large number of shipment and when I drag the formula it becomes B5 , B6 etc which doesn't work for me since the price is just a single cell.
Any help would be really appreciated.

**Moo the Dog** · 11-24-2013, 04:21 PM

Use absolute references for price:

=SUM(D4*MASTER_Data_1!B$4)+(E4*MASTER_Data_1!C$4)+(F4*MASTER_Data_1!D$4)

- Moo

**dredwolf** · 11-24-2013, 04:24 PM

if I understand righ, use the absolute referencing of $, ie:
=SUM(D4*MASTER_Data_1!$B$4)+(E4*MASTER_Data_1!$C$4)+(F4*MASTER_Data_1!$D$4)
to lock that cell, then when you drag only D4,E4, and F4 will change

Hope this helps

**FDibbins** · 11-24-2013, 04:24 PM

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.