3-D Reference

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

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?
 
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.
 
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.
 
Back
Top