3-D Reference

[tates]

I have a workbook with 13 tabs, Summary + Jan - Dec. On the monthly tabs
there are 22 line items each totaled in cell H. I want to pull the total for
each line item (cell H) from each monthly tab and have them totaled on the
Summary sheet in the Y-T-D cell for that line item.

Can you tell me how to do this?

 

[L. Howard Kittle]

Did you try the solutions from your identical post yesterday?

 

[T. Valko]

see your other post

 

[Bob I]

on the summary sheet in the cell you want the total, put = sign and then
click on the H cell in the January sheet. No look at the Cell on the
Summary sheet. add a +, the rest will be obvious.

 

[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 from each of the monthly tabs.