excell formula

Associate
Joined
19 Jul 2006
Posts
1,847
Is this possible? I have a spreadsheet with lots of worksheets in now i need to create a new worksheet that summarises all that data.
The work sheets are named after places
I want to do a formula thats psedo coded like
= ('avon'!G24+'Birmingham'!G24 ect / 30) is there a quick way of doing this with out having to type all the names in or clicking each sheet?
 
Afraid not, you have to type in the names of each sheet, or click on the cell itself to have excel put in the reference for you - but that's likely to be more time consuming.
 
Assuming you will be adding your summary sheet as the first sheet (left most tab of your worksheet tabs), you could use the following formula :

=Sum(Sheet2:SheetX!G24)/30

Where Sheet2 is the name of the second worksheet (e.g. Avon) in your workbook and SheetX with the last worksheet name (e.g Zanzibar).
 
Back
Top Bottom