Sum of specific cell from several worksheets
 

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.

Sum of specific cell from several worksheets
 

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.

Sum of specific cell from several worksheets
 

What are the sheet names?

Try this something like this...

=SUM(Sheet1:Sheet12!A1)
=SUM(Jan:Dec!A1)
=SUM(January:December!A1)

--
Biff
Microsoft Excel MVP


"richzip" wrote in message
...
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.