Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add across sheets in a workbook
Hi,
I have a workbook that has 30 sheets in it, I want to add up the same cell no across all 30 sheets to give me a total. how do you do this?? James |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add across sheets in a workbook
=sum([first sheet]:[last sheet]![cell])
One practice I use for this sort of thing is to create a 'first' and 'last' sheet and then sum everything between these two. Advantages a 1. you can change the sheet order without messing up the sum. 2. you can move sheets into and out of the total by just dragging them to a point after 'last' sheet. 3. keeps it simple when checking if tabs are 'in' or 'out' of the calculation. So: =sum(First:Last!A1) HTH Giz "JamesHenry" wrote: Hi, I have a workbook that has 30 sheets in it, I want to add up the same cell no across all 30 sheets to give me a total. how do you do this?? James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Sheets Copied From One Workbook to Another Without ....? | New Users to Excel | |||
selecting a single sheet from a volume of sheets in a workbook | Excel Worksheet Functions | |||
Copy formatted in several sheets of a workbook | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) |