Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Range of Worksheets Sum
I want the sum of a cell from a range of worksheets. What is the formula?
|
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
=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? |
#4
|
|||
|
|||
=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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
#8
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
Merge Worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |