Averaging Formula
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.
I am trying the formula from joeu2004
=IF(COUNT(B2:INDEX(B2:B1000;D1))=D1;0; ROUNDUP(MAX(0;D2-SUM(B1:INDEX(B2:B1000;D1)))/(D1-COUNT(B2:INDEX(B2:B1000;D1)));D3))
Values in B2 to B4 are .85, .60, .25. Values in D1 to D3 are 10, .8, 2.
The formula is in F1.
The result of the formula is 0 (zero) - which does not seem correct.
What am I doing incorrectly ?
|