Thread: 3-D References
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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