Hello,
I'm sure this can be done pretty easily but I can't seem to come up with a simple way to do this.
Sales Amount = Amount ($1,500)
Number of Sales (can vary depending on current month sales and prior month sales)
# of Payments = 6 (same # of payments for all sales)
What I'd like to do is calculate the total amount of sales each month (Jan - Dec) but spread the amount evenly given the number of sales made in the current month and the previous months.
For example, if 1 new sale is made in January (that amount would be included for 6 months), 2 new sales in February (would show 2 new sales and previous amount for January) and no sales in March (would show previous sales for Jan and Feb).
The outcome would be the following by month: $1,500 January, $4500 February, $4,500 in March
I want a formula that will calculate the total but also take into a count that each sale is to be spread over 6 months.
Any help in solving this is greatly appreciated!
I'm sure this can be done pretty easily but I can't seem to come up with a simple way to do this.
Sales Amount = Amount ($1,500)
Number of Sales (can vary depending on current month sales and prior month sales)
# of Payments = 6 (same # of payments for all sales)
What I'd like to do is calculate the total amount of sales each month (Jan - Dec) but spread the amount evenly given the number of sales made in the current month and the previous months.
For example, if 1 new sale is made in January (that amount would be included for 6 months), 2 new sales in February (would show 2 new sales and previous amount for January) and no sales in March (would show previous sales for Jan and Feb).
The outcome would be the following by month: $1,500 January, $4500 February, $4,500 in March
I want a formula that will calculate the total but also take into a count that each sale is to be spread over 6 months.
Any help in solving this is greatly appreciated!