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

 

[Pecoflyer]

In you summary sheet enter "=sum(" (no quotes)
Select the cell that should be summed ( in the summary sheet)
Then click on the tab of the first sheet to sum
While pressing the shift button select the last sheet's tab
Type the closing parenthesis in your formula

Should look like =SUM(Sheet1:Sheet12!G12)

 

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