Excel Formula -Simplifying formula

[workrelated]

Hi,

I need to simplify a formula, please refer to the screen below.

I will need help for row12 (E12, F12, G12, H12).

Is there any that i can do it in a single formula, instead of doing it manually ?

Thaks

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	Quantity	Items	Price	Single Price	Ben	Aex	Paul	Smith
2	1	Fried Chic Burger	18	18	1
3	1	BBQ Chic Pizza	21	21		1
4	1	Truffle Fries	15	15		1
5	2	Spec Source C.Chop	32	16		1		1
6	3	Salted Egg C.Chop	54	18	1	1	1
7	1	Ice Lemon Tea	6	6		1
8	1	Ice Honey Lemon	6	6	1	1
9	1	Passion F Shake	13	13		1
10	1	Glass	10	10			1
11	6	Warm Sky Juice	6	1	2	2	1	1
12		Total	181		44	97	29	17
Sheet1

Cell Formulas
Range	Formula
D2	=C2/A2
D3	=C3/A3
D4	=C4/A4
D5	=C5/A5
D6	=C6/A6
D7	=C7/A7
D8	=C8/A8
D9	=C9/A9
D10	=C10/A10
D11	=C11/A11
C12	=SUM(C2:C11)
E12	=E2*D2+E6*D6+E8*D8+E11*D11
F12	=F3*D3+F4*D4+F5*D5+F6*D6+F7*D7+F8*D8+F9*D9+F11*D11
G12	=G6*D6+G10*D10+G11*D11
H12	=H5*D5+H11*D11

 

[dave2018]

in E12:

=SUMPRODUCT(E2:E11,$D$2:$D$11)

Drag using the fill handle to the right...

Does that help?

 

[Aladin Akyurek]

Judging from your post, you are doing it with formulas, not manually.

In E2 enter and copy across:

=SUMPRODUCT($C$2:$C$11/$A$2:$A$11,E2:E11)

which does not need D2:D11.

 

[workrelated]

thanks this is helpful