Sum all sheets

  • Thread starter Thread starter wally
  • Start date Start date
W

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
 
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
 
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(alpha:omega!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.
 
"Gary"s Student"
Thanks, it does work and I appreciate your trying it out first. You guys do
a great job.
Wally
 
Back
Top