3-D References

[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?

 

[L. Howard Kittle]

Hi tates,

Something like this should get you there.

=SUM(Sheet1!A2,Sheet12!A2)

HTH
Regards,
Howard

 

[tates]

This isn't working. I'm not getting a Grand Total in the Y-T-D column which
is what I need.

 

[tates]

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.

 

[tates]

Yes - this gave me exactly what I needed. Thank you so much.