Counting down an average

  • Thread starter Thread starter Maddoktor
  • Start date Start date
M

Maddoktor

Hi all,

I hope someone can help me with my problem. I have a spreadsheet with 3
columns. Column A = Date, Column B = Achieved, Column C = Average per/day to
achieve target. If the target for the month is 300 and there is 30 days then
the average is 10 per day for the month. if I was to produce on the first
day of the month 10 then average for the remaining days for the month is 10.
If I was to produce only 5 on the second day of the month then I would like
the average to be the total remaining (I.e 300-15) divided by the number of
days remaining (I.e 30-2 = 28) to give me the average per day for the
remaining number of days.

I was wondering if this is possible.
 
You can use following formula

'=($B$2-SUM($B$6:B6))/($B$3-COUNT($A$6:A6))

where
B2 = Monthly Target
B3 = Days in the month

A6= Date, B6 = Achieved and the formula is entered in cell C6

See following picture of the same stored at:

http://tinypic.com/1t7bxu

Hope this helps. (hope i understood your question correctly ;)
~Yogendra
 
Back
Top