Calculating Month to Date on a Summary Sheet

[Guest]

Good Morning. I have a summary sheet for an entire month of data, and 31 seperate tabbed sheets for each day of the month. Is there a quick way to set up the month to date summary 'totals' in each cell? Currently, I am holding control and going into each cell on 31 sheets after =sum
I'm sure there is a quick way to calculate, and I hope so, as I have about 15 cells that I would like to calculate on the summary page
Any help would be greatly appreciated!!
Thank you
Bradle

 

[Peo Sjoblom]

If the cells are always the same, type =sum(
select the first sheet, hold down shift
and click the last sheet tab, then select the cell(s), finish by pressing
enter
will return for instance

=SUM('1:31'!A1:A6)



--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Good Morning. I have a summary sheet for an entire month of data, and 31

seperate tabbed sheets for each day of the month. Is there a quick way to
set up the month to date summary 'totals' in each cell? Currently, I am
holding control and going into each cell on 31 sheets after =sum(

I'm sure there is a quick way to calculate, and I hope so, as I have about

15 cells that I would like to calculate on the summary page.

 

[Bob Phillips]

Bradley,

Is it not as simple as

=SUM('Day 1ay 31'!A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Good Morning. I have a summary sheet for an entire month of data, and 31

seperate tabbed sheets for each day of the month. Is there a quick way to
set up the month to date summary 'totals' in each cell? Currently, I am
holding control and going into each cell on 31 sheets after =sum(

I'm sure there is a quick way to calculate, and I hope so, as I have about

15 cells that I would like to calculate on the summary page.

 

[Frank Kabel]

Hi
try
=SUM('sheet1:sheet31'!A1:A100)

 

[Dave Peterson]

On top of all the other responses, you may want to insert two "dummy"
worksheets--one to the right of all the worksheets to be included and one to the
left.

Call the Start and End. Then you can use:

=sum('start:end'!a1)

And you can drag sheets in between these two (or out of) and not have to worry
about adjusting the formula.