Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average throughout the sheets
hi all,
I have 17 sheets, the 17th one is the Summary sheet. Now in the cell B2 of the 17th sheet I want to calculate the average of the cells B2 in all the 16 sheets, what will be the easiest way to do it? the sheet tabs are named as Agent 1.......Agent 16. is it something like =AVERAGE(Agent 1:Agent 16,B2) Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average throughout the sheets
I think you might have to click on every sheet:
=AVERAGE('Agent 2'!B2,'Agent 1'!B2) etc "Gary" wrote: hi all, I have 17 sheets, the 17th one is the Summary sheet. Now in the cell B2 of the 17th sheet I want to calculate the average of the cells B2 in all the 16 sheets, what will be the easiest way to do it? the sheet tabs are named as Agent 1.......Agent 16. is it something like =AVERAGE(Agent 1:Agent 16,B2) Thanks in advance for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average throughout the sheets
Thanks Cin..but i worked it out.
I created 2 more sheets one in the beginning named 'Start' and one in the end named 'End'. Frmula in cell B2 on summary sheet - =Average(Start:End!B2) Thanks though. "Cin" wrote in message ... I think you might have to click on every sheet: =AVERAGE('Agent 2'!B2,'Agent 1'!B2) etc "Gary" wrote: hi all, I have 17 sheets, the 17th one is the Summary sheet. Now in the cell B2 of the 17th sheet I want to calculate the average of the cells B2 in all the 16 sheets, what will be the easiest way to do it? the sheet tabs are named as Agent 1.......Agent 16. is it something like =AVERAGE(Agent 1:Agent 16,B2) Thanks in advance for any help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average throughout the sheets
Gary
Very close. =AVERAGE('Agent 1:Agent 16'!B2) If you are going to be adding any new sheets it may be best to place a dummy sheet at each end of your sheets. Name them Start and End Then =AVERAGE(Start:End!B2) Now when inserting Agent 17, Agent 18 etc. make sure they are between Start and End sheets. Will be included in the formula. Gord Dibben MS Excel MVP On Mon, 5 Feb 2007 15:09:17 -0700, "Gary" wrote: hi all, I have 17 sheets, the 17th one is the Summary sheet. Now in the cell B2 of the 17th sheet I want to calculate the average of the cells B2 in all the 16 sheets, what will be the easiest way to do it? the sheet tabs are named as Agent 1.......Agent 16. is it something like =AVERAGE(Agent 1:Agent 16,B2) Thanks in advance for any help. |
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 |