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

R

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.
 
D

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.
 
R

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

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
[email protected]
Rob said:
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)
Click to expand...
 
Top