Help with formula to build sales based on new customers

[RoWood]

Hi There,

Hopefully someone has more experience than me ans can help me out with a formula I am struggling to find!

I am tying to create a spreadsheet that allow me to look at growth rate based on sales over a 24 month period where 2 new customers come on board every month for 24 months they spend a different amount each month. Example month 1 I have 2 customers spend 1000 each, then in month 2 they spend 500 each but also in month 2 I have 2 new customers spending 1000 each so total would be 2 X 1000 and 2 X 500, then in month 3 I will have 2 new customers spending 1000, 2 who are in month 2 spending 500 and 2 who are in month 3 spending say 600 etc etc - Is there a formula or set up that could work for this. Appreciate any help. Have spend last few hours trying to work it out and failed!


Thanks
Ro