# multiple sums in a formula

#### Nascarnut

##### New Member
Please help. I'm trying to impress my new boss by opening my big mouth
and telling him I know tons about excel. Now i'm stuck
I can't seem to get this formula to work.
TRUSS02.XLS
CDEFGHIJKL
1
2BOARDFEETLABORRATEBURDENRATEMATERIALPRICEMARKUPTOTAL
3
41236601.60\$1,259.0030%
5
6INEEDTOTAKETHESUMOFD4/E4,20.60
7THENMULTIPLYTHATTOTALBYF4,20.60*1.60=32.96
9ANDTHENMULTIPLYBYH41312.56*1.30=1706.33
11
Sheet1

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
=(((D4/E4)*(1+F4))+G4)*(1+H4)

Here you go...

=SUM(((D4/E4)*F4)+G4+(SUM(D4/E4)))*SUM(1+H4)

Ivan Howard said:
Here you go...

=SUM(((D4/E4)*F4)+G4+(SUM(D4/E4)))*SUM(1+H4)

Ivan - Why do you use the SUM function in this at all?

Thank You to all who helped me.
Both of your formulas worked great!!
Drinks are on me next time!!

Replies
4
Views
833
Replies
4
Views
145
Replies
3
Views
2K
Replies
4
Views
255
Replies
6
Views
610

1,203,529
Messages
6,055,933
Members
444,836
Latest member
nVaNL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back