Can you add fields from other sheets for a grand total?

[Rob]

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 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]

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)

 

[Don Guillett]

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 address 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)

 

[Rob]

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

 

[Dave Peterson]

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

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