LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Orf
 
Posts: n/a
Default How to calculate average from large dataset in several sheets?

I have a table that looks like the example below.

There are several of these tanks with input data on each sheet and there are
12 sheets in the workbook. I want to make a page where I calculate the
average of all the input data, irrespective of which tank the data comes
from. So the average of all the input data. How do I do this?

Tank A.
Date 10 12 13 17 20
Result 2 3 3 4 3



Average 2 3 3 4 3
Bulknr. 106445 106457 106457 106502
Sats. AA AA AA AA
Sign HE HE HE LF

Tank B.
Date 10 12 13 17 20
Result 2 3 3 4 3



Average 2 3 3 4 3
Bulknr. 106445 106457 106457 106502
Sats. AA AA AA AA
Sign HE HE HE LF

 
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
Spreadsheet Won't Calculate Scott Excel Discussion (Misc queries) 0 September 29th 05 05:37 PM
new sheets by this pc cannot calculate formulas Jeffry61 Excel Discussion (Misc queries) 12 September 23rd 05 07:21 PM
calculate totals of 5 sheets on to 6th sheet. salvo Excel Worksheet Functions 1 March 25th 05 06:58 AM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM


All times are GMT +1. The time now is 01:31 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"