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 all. Those work. It got me thinking of another sceanrio where this would be helpful.

If I have 10 tests in my semester and my grades are like this:

Test Score
1 50%
2 75%
3 80%
4 40%
5
6
7
8
9
10

What do I need to average on the remaining tests inorder to attain an 85% average. I tried to adapt the formulas posted but could not get it to work correctly.