Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jimenda
 
Posts: n/a
Default Averages

I have 55 worksheets in a file, they are all formatted the same way. Each
sheet has totals entered for individuals by catagory and by date. I would
like to create a new worksheet that I can display totals and averages from
the data on the other 55 sheets. Is there a way I can achieve this short of
typing out all the locations for each sum or average?
--
Thank You & God Bless,

Jimenda
 
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
Any software for charting moving averages? socraticquest Excel Worksheet Functions 7 December 19th 05 05:11 PM
Function for generating monthly & weekly averages picklet222 Excel Worksheet Functions 4 December 8th 05 09:00 PM
Trouble Sorting Averages of Randomly Generated Numbers GStrawley Excel Discussion (Misc queries) 3 September 5th 05 10:39 PM
calculating averages Golf Averages Excel Discussion (Misc queries) 1 August 15th 05 08:25 PM
Converting Weekly Data into Monthly Averages Kaine Excel Discussion (Misc queries) 2 February 25th 05 09:03 AM


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

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

About Us

"It's about Microsoft Excel"