Hi,

Am Tue, 4 Jun 2013 12:26:34 +0100 schrieb Bootface:

I am currently trying to create a formula that will change my targeted
hours based on the actual hours that I complete each week. For example
I have 300 hours split evenly over 52 weeks to give me my target hours
for each week. Column A shows the week number, Column B shows the
targeted hours for the week, Column C is where I input the actual hours
completed. When I input the hours in column C I need the target hours
for the remaining weeks to change so that I can see if they are on
target to achieving the 300hrs in the year.

in B1 try:
=300/COUNT(A1:A60)
in B2 try:
=IF(C1=0,B1,(300-SUM($C$1:C1))/COUNT(A2:$A$60))
and copy down to the last week number


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2