Range of Worksheets Sum

[Guest]

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

 

[Bob Phillips]

=SUM(Sheet1:Sheet2!A2)

will sum cell A2 on sheets 1 through 2.

 

[Peo Sjoblom]

=SUM(Sheet1:Sheet30!D110)

as an example

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

=Sheet2!A1+Sheet3!A1 will sum cell A1 across two worksheets

 

[Guest]

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

 

[Peo Sjoblom]

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)

 

[Ragdyer]

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

http://tinyurl.com/dhoaz

 

[Guest]

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