Sum all sheets
 

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

Sum all sheets
 

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.
--
Gary''s Student - gsnu200785


"wally" wrote:

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

Sum all sheets
 

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" wrote:

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.
--
Gary''s Student - gsnu200785


"wally" wrote:

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

Sum all sheets
 

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 - gsnu200785


"wally" wrote:

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" wrote:

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.
--
Gary''s Student - gsnu200785


"wally" wrote:

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

Sum all sheets
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gary''s Student" wrote in message
...
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 - gsnu200785


"wally" wrote:

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" wrote:

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.
--
Gary''s Student - gsnu200785


"wally" wrote:

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

Sum all sheets
 

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

"Gary''s Student" wrote:

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 - gsnu200785


"wally" wrote:

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" wrote:

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.
--
Gary''s Student - gsnu200785


"wally" wrote:

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