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.... )

[TABLE="width: 695"]
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Unit Price[/TD]
[TD]HW Shipping
Rate per item[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]$5,000 [/TD]
[TD]$29 [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]$6,000 [/TD]
[TD]$29 [/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]$7,000 [/TD]
[TD]$29 [/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]$8,000 [/TD]
[TD]$59 [/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]$9,000 [/TD]
[TD]$59 [/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]$12,000 [/TD]
[TD]$59 [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]$15 [/TD]
[TD]$49 [/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]$3 [/TD]
[TD] [/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD]$6 [/TD]
[TD] [/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD]$13,000 [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD]Sub-Total Hardware Capital (One Time)[/TD]
[TD] $ - [/TD]
[TD]$136,085 [/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD] [/TD]
[TD][/TD]
[TD]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[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

 

[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!