LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tammy
 
Posts: n/a
Default Yearly total average?

I have made a spreadsheet to keep attendance based on percentages. I want to
be able to insert a formula in the last column to calculate a running average
total. Example, at the end of March they have 100%, but in April they only
have 50% attendance, so the yearly would be 87.5%.

It can't be that difficult, but I can't figure out how to do it. Plus, I
don't want to change the formula each month.

THANKS
--
Tammy
 
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
Calculation help from average total Middlemix Excel Worksheet Functions 1 February 16th 06 01:26 PM
Pivot table for reporting sales performance Ram Excel Discussion (Misc queries) 2 February 6th 06 10:06 AM
Formatting minutes and seconds to calculate a total average VeronicaO Excel Worksheet Functions 4 October 6th 05 08:42 PM
Percent of total in Pivot tables Pallet1210A Excel Worksheet Functions 1 September 8th 05 07:12 PM
Pivot Table -- Add column to average Grand Total Lynn Excel Worksheet Functions 1 August 30th 05 03:59 PM


All times are GMT +1. The time now is 11:11 AM.

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"