Averaging Formula
I have 20 days in my sales cycle. As each day passes, I record a sales figure in the associated cell. My sales goal is to hit 100 sales for the 20 day period. Given that, is there a formula that I can use to calculate the average sales per days that remain that I would need to make inorder to hit the goal of 100 sales ?
Day Sales
1 3
2 2
3 5
4 7
5 0
Thanks in advance.
|