Ensure that the YTD sheet is placed outside of the group of 12 monthly
sheets. Ensure that the 1st month (eg: Jan 09) and last month (eg: Dec 09)
sheets are the "bookends", ie placed at the leftmost and rightmost parts in
that group of 12.

Then in YTD,
you could this: =SUM('Jan 09:Dec 09'!A1)
Success? wave it, hit the YES below
--
Max
Singapore
xde
---
"richzip" wrote:
I have a workbook with 12 worksheets, one for each month of the year. I also
want to add a "year to date" worksheet. Is there a simple way to take the
sum and/or average of a specific cell, over the 12 month period, and carry it
over to the same cell on the YTD worksheet?

Example: I have a "total pay" in cell A1, on each of the 12 worksheets. I
want the sum of all of the A1 cells to compute in cell A1 on the YTD
worksheet.