| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals in worksheete groups
How do I total worksheet groups? I have a series of continguous worksheets.
The first is called Summary, the rest A, B, C, D, E etc. I want to total cell A1 from worksheets A,B,C,D,E etc and put the total in Cell A1 in the summary -- Thanks BJ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals in worksheete groups
=SUM(A:E!A1)
top apply it, select the cell where yoiu want the totals, type =SUM( click the first sheet tab (A) and cell A1, hold down shift and click the last (E) press enter -- Regards, Peo Sjoblom "BJ" wrote in message ... How do I total worksheet groups? I have a series of continguous worksheets. The first is called Summary, the rest A, B, C, D, E etc. I want to total cell A1 from worksheets A,B,C,D,E etc and put the total in Cell A1 in the summary -- Thanks BJ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals in worksheete groups
It's called a 3d sum, and the formula in Summary!A1 will read =sum(A:E!A1).
You can type the entire formula or start typing =sum( then click on A!A1, shift-click on the tab of the final sheet (E) in your range, then hit enter. --Bruce "BJ" wrote: How do I total worksheet groups? I have a series of continguous worksheets. The first is called Summary, the rest A, B, C, D, E etc. I want to total cell A1 from worksheets A,B,C,D,E etc and put the total in Cell A1 in the summary -- Thanks BJ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals in worksheete groups
BJ
In A1 of Summary sheet enter =SUM(A:E!A1) I prefer to add a sheet after Summary sheet. Name it Start Add a sheet at end of sheets. Name it End. Formula in Summary sheet =SUM(Start:End!A1) When adding new sheets insert between Start and End sheets. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:41:49 -0800, "BJ" wrote: How do I total worksheet groups? I have a series of continguous worksheets. The first is called Summary, the rest A, B, C, D, E etc. I want to total cell A1 from worksheets A,B,C,D,E etc and put the total in Cell A1 in the summary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding up totals of groups | Excel Discussion (Misc queries) | |||
| Dealing with worksheet groups | Excel Worksheet Functions | |||
| Pivot Table Totals | New Users to Excel | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
| how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
Linear Mode
