Is there a better way to Mutiply and then Add than below?

[Beginner35]

Hello: Is there an easier formula to do this Total Cost=( Unit Price1 x Qty1 + Unit Price2 x Qty2 + Unit Price3 x Qty3 + Unit Price4 X Qty4 etc.... )

1	A	D	E
2	Unit Price	HW Shipping Rate per item	L
3	$5,000	$29	1
4	$6,000	$29	2
5	$7,000	$29	3
6	$8,000	$59	4
7	$9,000	$59	6
8	$12,000	$59	1
9
10
11
12
13
14	$15	$49	2
15	$3		6
16	$6		6
17	$13,000
18	Sub-Total Hardware Capital (One Time)	$ -	$136,085
19			E3*$A3+E4*$A4+E5*$A5+E6*$A6+E7*$A7+E8*$A8+$A9*E9+$A10*E10+$A11*E11+$A12*E12+$A13*E13+E14*$A14+E15*$A15+E16*$A16+$A17*E17

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

 

[DebugGalpin]

There is but I can't remember it. If you need it quick you could add another column with the formula then sum that column

 

[Joe4]

Try this:

=SUMPRODUCT(A3:A17*E3:E17)

 

[Rick Rothstein]

Give this formula a try...

=SUMPRODUCT(E3:E17*A3:A17)

Note: You will have to use Cell Formatting to make this display as a Currency amount.

 

[tcardwell]

Hello,

To keep it simple you can use a new column F to accumulate all of your row totals e.g. =e3*a3 and then copy this formula all the way down to row 17. Then in row 18 you can use the sum formula by just clicking and dragging in column F for the range that you want to sum up.

 

[Beginner35]

Thanks everyone! I forgot about SUMPRODUCT.. Works like magic!