sum a large number of worksheets
 

Hi, I need to set up a worksheet that will summarise the data in the other
worksheets in the workbook.

Each worksheet has a different name eg Area N2, Area S2 etc.

I know this is easy but I could end up with over 100 worksheets that the
formula has to add up and so setting up the first formula will take ages.

Is there a quick way of setting the formula up or do I just have to get on
with it?

Thank you in advance of any replies

sum a large number of worksheets
 

On Wed, 21 Jan 2009 06:39:02 -0800, Michael wrote:

Hi, I need to set up a worksheet that will summarise the data in the other
worksheets in the workbook.

Each worksheet has a different name eg Area N2, Area S2 etc.

I know this is easy but I could end up with over 100 worksheets that the
formula has to add up and so setting up the first formula will take ages.

Is there a quick way of setting the formula up or do I just have to get on
with it?

Thank you in advance of any replies

Set up a sum cell in each worksheet in the same location (i.e. a:2000),
highlight all the worksheets, and name the cell range, sum the range.

sum a large number of worksheets
 

Thanks,

I'm trying to add up cell A1 on every sheet and put the answer in cell a1 on
the summary sheet.

So I have selected all of the worksheets and selected cell A1 and selected
Insert-Name-define but it only shows the range as being the active sheet even
though all of the sheets are grouped.

Am i doing something wrong?



"Michael Dobony" wrote:

On Wed, 21 Jan 2009 06:39:02 -0800, Michael wrote:

Hi, I need to set up a worksheet that will summarise the data in the other
worksheets in the workbook.

Each worksheet has a different name eg Area N2, Area S2 etc.

I know this is easy but I could end up with over 100 worksheets that the
formula has to add up and so setting up the first formula will take ages.

Is there a quick way of setting the formula up or do I just have to get on
with it?

Thank you in advance of any replies

Set up a sum cell in each worksheet in the same location (i.e. a:2000),
highlight all the worksheets, and name the cell range, sum the range.

sum a large number of worksheets
 

You can set up two (blank) worksheets, one called start the other
called end, and position them so that they form a "sandwich"
encompassing the sheets you want to sum from (i.e. your summary sheet
will be outside this "sandwich".

Then you can use a formula like:

=SUM(start:end!A1)

to add up all the A1 cells within that "sandwich". You can move sheets
into or out of this "sandwich" to model the effects.

Hope this helps.

Pete

On Jan 21, 2:39*pm, Michael wrote:
Hi, I need to set up a worksheet that will summarise the data in the other
worksheets in the workbook.

Each worksheet has a different name eg Area N2, Area S2 etc.

I know this is easy but I could end up with over 100 worksheets that the
formula has to add up and so setting up the first formula will take ages.

Is there a quick way of setting the formula up or do I just have to get on
with it?

Thank you in advance of any replies

sum a large number of worksheets
 

Thanks, much appreciated

"Pete_UK" wrote:

You can set up two (blank) worksheets, one called start the other
called end, and position them so that they form a "sandwich"
encompassing the sheets you want to sum from (i.e. your summary sheet
will be outside this "sandwich".

Then you can use a formula like:

=SUM(start:end!A1)

to add up all the A1 cells within that "sandwich". You can move sheets
into or out of this "sandwich" to model the effects.

Hope this helps.

Pete

On Jan 21, 2:39 pm, Michael wrote:
Hi, I need to set up a worksheet that will summarise the data in the other
worksheets in the workbook.

Each worksheet has a different name eg Area N2, Area S2 etc.

I know this is easy but I could end up with over 100 worksheets that the
formula has to add up and so setting up the first formula will take ages.

Is there a quick way of setting the formula up or do I just have to get on
with it?

Thank you in advance of any replies

sum a large number of worksheets
 

You're welcome - thanks for feeding back.

Pete

On Jan 21, 4:38*pm, Michael wrote:
Thanks, much appreciated