#1
|
|||
|
|||
Help with formula to build sales based on new customers
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 |
Tags |
formula help, salesbuild |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Documents for customers link to our work server! | andiekit | Word | 2 | 01-17-2020 04:08 AM |
Invoice overdue mail send to customers | Reky | Mail Merge | 4 | 09-30-2019 09:37 PM |
Build paragraphs based on selecting "yes" from a content control | jeffreybrown | Word VBA | 8 | 11-07-2018 04:02 PM |
How to create a formula in excel that can calculate a commission by sales tier ? | Skylark | Excel Programming | 1 | 05-06-2017 03:45 AM |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |