Calculate Ramped Spending

[Adamzurick]

Hi,

I'm hoping to create a formula in the "Total Launched Spending - (Formula)" row where it takes the Spending each customer is slated to do each month and gradually ramp that month's launched accounts by the "Account $ Ramp" table above. The trick is that each of the previous month's launched spending will still be occuring in the current month. I've included the "Value Check" so you can see the numbers I expect to be calculated. Just so you can see how I calculated the formulas, March's Launched Spend calculation formula of $15,000 is =(C10*C8*C6*E3)+(D10*D8*D6*D3)+(E10*E8*E6*C3) where (Month 1 launched spend) + (Month 2 launched spend) + (Month 3 launched spend) + ...

Final note, after Month 9 I'd like to keep the spending at the Month 9 ramped percentage.

Can you find a better way of doing this so the same formula is used across the months? I feel as though I can use a SUMPRODUCT but can't seem to get that to work. This is a simplified version of what I expect to use so looking for an easier way.

Thanks!

A1	B	C	D	E	F	G	H	I	J	K	L	M	N
2		Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9
3	Account $ Ramp	10%	25%	65%	55%	45%	42%	35%	20%	15%
4
5		01/01/2021	02/01/2021	03/01/2021	04/01/2021	05/01/2021	06/01/2021	07/01/2021	08/01/2021	09/01/2021	10/01/2021	11/01/2021	12/01/2021
6	Spending	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000	$ 15,000
7
8	Accounts Launched	1	1	1	1	1	1	1	1	1	1	1	1
9
10	People	1	1	1	1	1	1	1	1	1	1	1	1
11
12	Total Launched Spend - (Value Check)	$ 1,500	$ 5,250	$ 15,000
13	Total Launched Spend - (Formula)	?	?	?