On Wednesday, December 5, 2012 1:41:17 PM UTC-5, wrote:
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.

Thanks. That works well. And thank you for the in depth explanantion.