From: Thomas on 13 Jan 2010 09:38 I have been trying to understand this principle but need you to clarify your instructions. Example: C1 2010 (Year) To Avg. 35 (Title) C2 36 Formula (Need 34) C3 32 Formula (Need 37) C4 34 Formula (Need 38) The formula needs to adjust calculating all the weeks prior to it to be able to avg. 35 for the year Thank-you walrus wrote: Heya Thomaswhat you need is Goal Seek but you will have to do it weekly. 13-Jan-10 Heya Thomas what you need is Goal Seek but you will have to do it weekly. in the table below go to cell F2 (average formula) and in the DATA Menu > What-if analysis cick OK. you will see in cell C4 that you need 37 more to make your average 35. just paste this value in cell D4 and when you know the actual attendence just overwrite the 37 in cell C4 this way you also check your progress viz required and actual. A B C D E F 1 Attnd Attnd Req Avg Avg Req 2 Week1 36 35 =AVERAGE(\$C\$2:\$C\$53) =AVERAGE(\$C\$2:\$C\$53) 3 Week2 32 34 =AVERAGE(\$C\$2:\$C\$53) 4 Week3 37 =AVERAGE(\$C\$2:\$C\$53) "Thomas Almanza" wrote: Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET Session Variables - Hijack http://www.eggheadcafe.com/tutorials/aspnet/93b132b0-4d8e-4fb1-bfb1-c5283d523c8c/aspnet-session-variables.aspx  |