Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average throughout the sheets
Hi All,
If I have 16 sheets and then I have a summary sheets....now in Cell B2 of summary sheets I need to take the average of cell B2 in all the sheets......what is the easiest way? if the sheet tabs are named as Agent 1........Agent 16, can it be something like =AVERAGE(Agent 1:Agent 16,B2) Any help will be appreciated Thanks gary |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average throughout the sheets
=AVERAGE(Agent1:Agent16!A1)
The above averages the content of A1 in sheets 1 to 16 "Gary" wrote: Hi All, If I have 16 sheets and then I have a summary sheets....now in Cell B2 of summary sheets I need to take the average of cell B2 in all the sheets......what is the easiest way? if the sheet tabs are named as Agent 1........Agent 16, can it be something like =AVERAGE(Agent 1:Agent 16,B2) Any help will be appreciated Thanks gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the average across multiple sheets | Excel Worksheet Functions | |||
Average calcs - ignore sheets | Excel Worksheet Functions | |||
copying the same cells from many sheets | Excel Worksheet Functions | |||
Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |