| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-D Reference
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? -- Regards ~ tates |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D Reference
Did you try the solutions from your identical post yesterday?
"tates" wrote in message ... 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? -- Regards ~ tates |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D Reference
see your other post
-- Biff Microsoft Excel MVP "tates" wrote in message ... 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? -- Regards ~ tates |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D Reference
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 wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D Reference
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. -- Regards ~ tates "Bob I" wrote: 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 wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
Linear Mode
