LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Average Goal Calculation

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Calculation Munchkin Excel Worksheet Functions 4 September 4th 09 07:12 PM
Help understanding Goal Seek Calculation Chad[_4_] Excel Discussion (Misc queries) 3 January 13th 09 05:34 PM
Goal Seel To get Average!? Neo1 Excel Worksheet Functions 9 March 5th 06 12:54 AM
average calculation blackstar Excel Discussion (Misc queries) 1 February 4th 06 07:46 PM
overlay average & goal lines to bar graph w/out showing in legend Violet Maven Charts and Charting in Excel 1 July 12th 05 12:27 AM


All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"