How do I SUM several worksheet to a final worksheet?
 

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?

How do I SUM several worksheet to a final worksheet?
 

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(Jan:Dec!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....

How do I SUM several worksheet to a final worksheet?
 

Hi Michael,

try this

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

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

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=511004

How do I SUM several worksheet to a final worksheet?
 

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

"Michael Q" <Michael wrote in message
...
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?