I have multiple sheets in a doc each sheeet is formatted the same, each
sheet is one month basically, at the bottom of each sheet is a total for
each column, and I'd like to find out the sum of all columns for each sheet
combined.

If the sums are in the same location on each sheet, you could do this:

Insert a couple of worksheets--one to the far left of your worksheets to sum and
one to the far right. Call them Start and End.

Then insert another worksheet to hold the sums--but put it outside this
"sandwich" of worksheets.

Then you can use:

=sum('start:end'!a55)

to sum all the values in A55 for all the worksheets between start and end
(inclusive).

You can even drag a month out of this sandwich and see how it affects the sum.

Personally, I try to put the column Sums in row 1 of each worksheet. Then I
know where they are--and they're always visible when I freeze panes nicely.



Rob wrote:
>
> I have multiple sheets in a doc each sheeet is formatted the same, each
> sheet is one month basically, at the bottom of each sheet is a total for
> each column, and I'd like to find out the sum of all columns for each sheet
> combined.

--

Dave Peterson

No my sums didn't end in the same row all the time since some pages had more
transactions than others. But that wasn't a prob. I just moved them all to
the bottom of the page and tried your suggestion
=SUM(Sheet1:Sheet16!COLUMNLETTER52)


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If the sums are in the same location on each sheet, you could do this:
>
> Insert a couple of worksheets--one to the far left of your worksheets to
> sum and
> one to the far right. Call them Start and End.
>
> Then insert another worksheet to hold the sums--but put it outside this
> "sandwich" of worksheets.
>
> Then you can use:
>
> =sum('start:end'!a55)
>
> to sum all the values in A55 for all the worksheets between start and end
> (inclusive).
>
> You can even drag a month out of this sandwich and see how it affects the
> sum.
>
> Personally, I try to put the column Sums in row 1 of each worksheet. Then
> I
> know where they are--and they're always visible when I freeze panes
> nicely.
>
>
>
> Rob wrote:
>>
>> I have multiple sheets in a doc each sheeet is formatted the same, each
>> sheet is one month basically, at the bottom of each sheet is a total for
>> each column, and I'd like to find out the sum of all columns for each
>> sheet
>> combined.
>
> --
>
> Dave Peterson

If you moved all to the bottom (row 65536) you will create one big wb. I
suggest the top. Then, DELETE all those extra rows on each page and SAVE the
workbook. Notice the diff in file size.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Rob" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> No my sums didn't end in the same row all the time since some pages had
> more transactions than others. But that wasn't a prob. I just moved them
> all to the bottom of the page and tried your suggestion
> =SUM(Sheet1:Sheet16!COLUMNLETTER52)
>
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> If the sums are in the same location on each sheet, you could do this:
>>
>> Insert a couple of worksheets--one to the far left of your worksheets to
>> sum and
>> one to the far right. Call them Start and End.
>>
>> Then insert another worksheet to hold the sums--but put it outside this
>> "sandwich" of worksheets.
>>
>> Then you can use:
>>
>> =sum('start:end'!a55)
>>
>> to sum all the values in A55 for all the worksheets between start and end
>> (inclusive).
>>
>> You can even drag a month out of this sandwich and see how it affects the
>> sum.
>>
>> Personally, I try to put the column Sums in row 1 of each worksheet.
>> Then I
>> know where they are--and they're always visible when I freeze panes
>> nicely.
>>
>>
>>
>> Rob wrote:
>>>
>>> I have multiple sheets in a doc each sheeet is formatted the same, each
>>> sheet is one month basically, at the bottom of each sheet is a total for
>>> each column, and I'd like to find out the sum of all columns for each
>>> sheet
>>> combined.
>>
>> --
>>
>> Dave Peterson
>
>

Oh I just meant I moved them to the bottom of the page (row 52) , not row
65536 :P

"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you moved all to the bottom (row 65536) you will create one big wb. I
> suggest the top. Then, DELETE all those extra rows on each page and SAVE
> the workbook. Notice the diff in file size.
>
> --

I still like to put them in row 1. <bg>

Rob wrote:
>
> Oh I just meant I moved them to the bottom of the page (row 52) , not row
> 65536 :P
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > If you moved all to the bottom (row 65536) you will create one big wb. I
> > suggest the top. Then, DELETE all those extra rows on each page and SAVE
> > the workbook. Notice the diff in file size.
> >
> > --

--

Dave Peterson