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?