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?

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

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

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