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?