I am trying to maintain an average of 35 in Sunday School. Each week I input the number of attendees in my excel file. I need a formula that will tell me how many I need next Sunday, to make my year long goal of 35 as an average. For Ex:

A B C

1 Date # of Attendees #needed next week to avg 35

2 1/3/10 34 (? Formula so #36 would show)

3 1/10/10 38 (? Formula so #34 would show)

4. Etc. Etc. Etc.

Please help!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Using the WebResource.axd Handler with Embedded ASP.NET Resources
http://www.eggheadcafe.com/tutorials...sourceaxd.aspx