Formula to add range and multiply by two different percents

[jasonmd2]

I'm trying to add a range and multiply by a percent, and then take that total and multiply that by a different percent and return that result in a cell.

I have data in cells A1:D1 and I want to add them and then multiply that result by the number in cell E1, then take that total and multiply it by the number in cell F1 and then return that result in cell G1.

Here's what I currently have =SUM((A1:D1)*E1,+(A1:D1)*F1+(A7:D7)) and I know it's not doing what I want, lol

Thanks in advance for any help!!

 

[awoohaw]

In cell G1:

=(sum(A1:D1)*E1)*F1

Book1
	A	B
1	25
2	25
3	25
4	25
5	50%
6	50%
7	25	=(SUM(A1:A4)*A5)*A6
Sheet1

Cell Formulas
Range	Formula
A7	A7	=(SUM(A1:A4)*A5)*A6
B7	B7	=FORMULATEXT(A7)

 

[Peter_SSs]

In cell G1:

=(sum(A1:D1)*E1)*F1

.. or removing the superfluous parentheses

=SUM(A1:D1)*E1*F1

 

[jasonmd2]

Thanks for the replies guys, but that formula doesn't work, it's returning a result of 23.93 and it should be 1140.69, based on the data set example attached.

 

[awoohaw]

Your original question did not include adding the original amount. You were adding the Percentages first, and not multiplying them separately:

Book1
	A	B	C	D	E	F	G
3	512.68	60		225	10%	30%	1140.682
4							1116.752
Sheet4

Cell Formulas
Range	Formula
G3	G3	=SUM(A3:D3)*(1+E3)*(1+F3)
G4	G4	=SUM(A3:D3)*(1+(E3+F3))

 

[jasonmd2]

The solution in G3 was exactly what I was looking for, thank you!!!

 

[awoohaw]

Happy to help. Best Wishes.