I have Sales by Month and a profile of what % of each Amount will be collected in the month of sale, 1 month after sale etc.
What I need to do is calculate the total amount I will receive by month.
In the attached I need some way to calculate (on one row) the amounts io on theTotal Row.
I have tried Sumproduct but not working.
Any help would be appreciated.
Thank You
Allister
What I need to do is calculate the total amount I will receive by month.
In the attached I need some way to calculate (on one row) the amounts io on theTotal Row.
I have tried Sumproduct but not working.
Any help would be appreciated.
Thank You
Allister
Book1.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
8 | April | May | Months After Sales | 0 | 1 | 3 | 6 | ||||||
9 | Sales | $ 100.00 | $ 200.00 | Percentage of Amount Received | 10% | 20% | 30% | 40% | |||||
10 | |||||||||||||
11 | |||||||||||||
12 | April | May | June | July | August | September | October | November | Total Received | ||||
13 | 100*0.1 | 100*0.2 | 100*0.3 | 100*0.4 | $ 100.00 | ||||||||
14 | 200*0.1 | 200*0.2 | 200*0.3 | 200*0.4 | $ 200.00 | ||||||||
15 | |||||||||||||
16 | |||||||||||||
17 | Total | 10 | 40 | 70 | 60 | 40 | 80 | $ 300.00 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K17 | K17 | =SUM(B17:J17) |