Adding Across Worksheets

  • Thread starter Thread starter Dimetric Houston
  • Start date Start date
D

Dimetric Houston

Hello all.

I saw a thread talking about this, but I can't figure out how to make it
work for me.

My worksheets contain the contribution for each person for one day out
of the week. One issue I have is that all my worksheets have the date
for the worksheet name (it is easier to see what a person contributed on
a certain day if the date is immediately visible on the tabs).

I want to sum all the contributions for each person over the course of
about 6 months. There are about 70+ people, and I want to show what
each person contributed totally. Is there a way to do this using the
SUM formula?

I don't think this would be a conditional sum, unless I have to account
for blank cells outside the range of names and totals.

Thanks.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
Is each person's name in the same location on each sheet?

If yes, say your info that you want to sum is in E19 of each sheet.

I'd add two sheets--one to the far left named Start and one to the far left
named Finish.

Then make sure your summary sheet is not between the Start/Finish worksheets.

Then you can use:
=sum(start:finish!e19)
 
Hey, that's fantastic! I'll use that.

Here is a type of example of how my data looks:

Day 1
Name Contrib A Contrib B Total
Joe 300.00 50.00 350.00
Sue 250.00 202.00 452.00
Billy 90.00 .10 9.10

Now, say that this type of setup is on each sheet (for about 50+ sheets,
Day 1 to Day 50).

What you gave me would, say, sum up Joe's contributions for the whole 50
sheets. Specifically, it would take the Total for Joe on each sheet and
sum them. Now, would I have to do a loop to do the same thing for Sue
and Billy, or is there a better way? A loop going through 70+ people on
50+ sheets would be pretty slow.

SUM seems pretty picky about its arguments. I thought of using Offset
in order to go to the next row, but that would get messy in dealing with
50+ sheets.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
If Sue's data were always in the same spot, you could just use that same
formula:

=sum(start:finish!e19)

But point at Sue's cell.

=sum(start:finish!e22) (say)
 
Back
Top