Sum all sheets

[wally]

I have a workbook, with multiple sheets, each with it's own name. Each sheet
has a cell, ie N25, which represents a count function on that sheet. Now, I
would like to place the sum of N25 of all the sheets on a summary sheet. Is
it possible to do this with or without using a macro? If it is, I could use
your help. Many thanks.

Wally

 

[Gary''s Student]

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.

 

[wally]

Thanks for your suggestion, but as I said in the first sentence, "I have a
workbook, with multiple sheets, each with it's own name". Your suggestion
will not do it. That is why I suggested something like =SUM(all sheets!N25).

Wally

 

[Gary''s Student]

We can make it work. I just created a workbook with three sheets:

alpha
beta
omega

(where alpha is the first and omega is the last and beta is in the middle)

=SUM(alphamega!N25)

picks up ALL the sheets (even beta) !

just be sure you specify the first and last sheetname in the SUM() formula.


Give it a try.

 

[Ron de Bruin]

For the OP, see also
http://www.rondebruin.nl/linksum.htm

 

[wally]

"Gary"s Student"
Thanks, it does work and I appreciate your trying it out first. You guys do
a great job.
Wally