3-D References
Hi tates,
Something like this should get you there.
=SUM(Sheet1!A2,Sheet12!A2)
HTH
Regards,
Howard
"tates" wrote in message
...
my workbook contains 13 sheets - 1 for each month of the year + a summary
sheet. Each sheet has 21 line items which contain a Total$Spent cell. I
need
to take the value in the Total$Spent cell for each month and add them to
arrive at a Y-T-D total for each line item on the summary sheet.
Can you tell me how to build this formula?
--
Regards ~ tates
|