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