I have a problem where a set number of new customers are coming online in each of the next five years (populated in cells A1:A5 as follows): 5, 3, 2, 4, 3. I am predicting that over five years the sales from a new customer will grow as follows (represented in cells B1:B5): $100, $125, $175, $225, $275, with $100 representing the sales to a customer in his first year with our company and $275 representing the sales in his 5<SUP>th</SUP> year.
The question I have is how to create a formula that sums my total expected sales over each of the next five years. I can do it through simple brute force, but is there an elegant way? I can see the spreadsheet growing down the road and I think if I'm just manually multiplying all the combinations I will regret it later.
The question I have is how to create a formula that sums my total expected sales over each of the next five years. I can do it through simple brute force, but is there an elegant way? I can see the spreadsheet growing down the road and I think if I'm just manually multiplying all the combinations I will regret it later.