Totals in worksheete groups

[Guest]

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

 

[Peo Sjoblom]

=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

 

[Guest]

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

 

[Gord Dibben]

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