Range of Worksheets Sum
 

I want the sum of a cell from a range of worksheets. What is the formula?

=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

--
HTH

Bob Phillips

"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the formula?

=SUM(Sheet1:Sheet30!D1:D10)

as an example

--
Regards,

Peo Sjoblom

(No private emails please)


"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the formula?

=Sheet2!A1+Sheet3!A1 will sum cell A1 across two worksheets
--
Gary''s Student


"JRM" wrote:

I want the sum of a cell from a range of worksheets. What is the formula?

The colon between two sheets does not work, but a plus sign does? I have
renamed by sheets by dates. In order to total a 6-day span, I must use each
day+each day + each day, etc. What is the formula to do weekly, i.e.,
6-04-05 thru 6/10/05?

JRM


"Bob Phillips" wrote:

=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

--
HTH

Bob Phillips

"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the formula?

Yes it does work unless you have some local regional settings that does not
recognize a colon
However Excel will put in the necessary character for you, first put

=SUM(

and then select the first sheet tab, hold down shift and select the last
sheet tab, now select the cell(s) and press enter
Done!

--
Regards,

Peo Sjoblom

(No private emails please)


"JRM" wrote in message
...
The colon between two sheets does not work, but a plus sign does? I have
renamed by sheets by dates. In order to total a 6-day span, I must use
each
day+each day + each day, etc. What is the formula to do weekly, i.e.,
6-04-05 thru 6/10/05?

JRM


"Bob Phillips" wrote:

=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

--
HTH

Bob Phillips

"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the
formula?

See if this old post can help explain what to do:

http://tinyurl.com/dhoaz

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JRM" wrote in message
...
The colon between two sheets does not work, but a plus sign does? I have
renamed by sheets by dates. In order to total a 6-day span, I must use
each
day+each day + each day, etc. What is the formula to do weekly, i.e.,
6-04-05 thru 6/10/05?

JRM


"Bob Phillips" wrote:

=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

--
HTH

Bob Phillips

"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the
formula?

Thank you very much for your assistance. You have made my task so much
simplier now that my boss has decided that he wants the entire year's data
weekly instead of monthly. Thanks again.

JRM

"Peo Sjoblom" wrote:

Yes it does work unless you have some local regional settings that does not
recognize a colon
However Excel will put in the necessary character for you, first put

=SUM(

and then select the first sheet tab, hold down shift and select the last
sheet tab, now select the cell(s) and press enter
Done!

--
Regards,

Peo Sjoblom

(No private emails please)


"JRM" wrote in message
...
The colon between two sheets does not work, but a plus sign does? I have
renamed by sheets by dates. In order to total a 6-day span, I must use
each
day+each day + each day, etc. What is the formula to do weekly, i.e.,
6-04-05 thru 6/10/05?

JRM


"Bob Phillips" wrote:

=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

--
HTH

Bob Phillips

"JRM" wrote in message
...
I want the sum of a cell from a range of worksheets. What is the
formula?