I am trying to average 35 every week in my Sunday school.
Last week, I had 32, the week before that 36. I would like a formula to tell me how many I need on the next Sunday, to average 35 for the year. All of the weeks are in column c (C2:C53) I would like 1 cell at the bottom of column c to have the answer continually update itself when I insert Sunday's attendance. What do I do?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crystal Report And Parameter Passing Using Stored Procedure
http://www.eggheadcafe.com/tutorials...nd-parame.aspx