How do I SUM several worksheet to a final worksheet?

[Guest]

Have created a worksheet that has tabs for each month of the year (beginning
with the second tab). On column H of each worksheet is a TOTAL column of
money given for that month. I have a fourteenth tab that is titled Year to
Date. How do I create a formula that will compute each month's giving to
that Year to Date worksheet so I can keep track of an individuals Year to
Date giving at any given time?

 

[christine.bastel]

Hi!

Assuming your sheets are called Jan, Feb, Mar... etc and the money for
that month is in column H:H (so not in one cell in H), the best way is:

=SUM(Janec!H:H)

should you have subtotals in Column H - they will be double counted,
so get rid of them...
Another way is to insert two tabs : Start, End name the function
=SUM(Start:End!H:H) and move the sheets you want to have added between
these tabs - a bit kleener....

 

[EdMac]

Hi Michael,

try this

=SUM(Sheet1:Sheet12!your common cell reference).

You can enter this by entering =Sum( and then select sheet 1 and whil
holding shift select the last sheet in the range. Then enter the cel
reference to be summed through the sheets.

E

 

[Bob Phillips]

=SUM(Jan:Feb!H1)

should do it, change to your names and cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)