Formula Question

[jdude]

I have an inventory sheet which includes weekly Purchases and I am looking for a way to add the units purchased for each week...then multiply that total by the purchase price and keep a running total for all items in the list.

Example:

Week1 Week2 Week3 Week4 Week5 Purchase Price Total Purchases
3 1 2 2 2 $20 $830
1 6 5 3 3 $35

I need the formula to add the weekly purchases then multiply by the linear purchase price for each row while keeping a running total.


I am stuck here so any help would be greatly appreciated!!

Thanks in advance!!

 

[gaz_chops]

Not clear from your example what result you want?

 

[gaz_chops]

Is it like this?

[TABLE="width: 488"]
<colgroup><col span="5"><col><col></colgroup><tbody>[TR]
[TD]Week1[/TD]
[TD]Week2[/TD]
[TD]Week3[/TD]
[TD]Week4[/TD]
[TD]Week5[/TD]
[TD]Purchase Price[/TD]
[TD]Total Purchases[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]2560[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jdude]

I was able to figure it out!
=SUMPRODUCT(E8:E703,H8:H703)+SUMPRODUCT(E8:E703,I8:I703)+SUMPRODUCT(E8:E703,J8:J703)+SUMPRODUCT(E8:E703,K8:K703)+SUMPRODUCT(E8:E703,L8:L703)

I just had to simplify my train of thought.

Thank you for your reply and help!!

 

[gaz_chops]

Was my example correct?

If so then try

=SUMPRODUCT((A2:E10)*(F2:F10))