3-D References

  • Thread starter Thread starter tates
  • Start date Start date
T

tates

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?
 
Hi tates,

Something like this should get you there.

=SUM(Sheet1!A2,Sheet12!A2)

HTH
Regards,
Howard
 
This isn't working. I'm not getting a Grand Total in the Y-T-D column which
is what I need.
 
I'm not getting anything in the Y-T-D column which should be a Grand Total of
that specific line item in cell h2 on each of the monthly tabs.
 
Back
Top