| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-D References
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? -- Regards ~ tates |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D References
Hi tates,
Something like this should get you there. =SUM(Sheet1!A2,Sheet12!A2) HTH Regards, Howard "tates" wrote in message ... 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? -- Regards ~ tates |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D References
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) -- Pecoflyer Cheers - *_Membership_is_free_* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43854 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D References
This isn't working. I'm not getting a Grand Total in the Y-T-D column which
is what I need. -- Regards ~ tates "L. Howard Kittle" wrote: Hi tates, Something like this should get you there. =SUM(Sheet1!A2,Sheet12!A2) HTH Regards, Howard "tates" wrote in message ... 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? -- Regards ~ tates |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D References
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. -- Regards ~ tates "Pecoflyer" wrote: 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) -- Pecoflyer Cheers - *_Membership_is_free_* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43854 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3-D References
Yes - this gave me exactly what I needed. Thank you so much.
-- Regards ~ tates "Pecoflyer" wrote: 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) -- Pecoflyer Cheers - *_Membership_is_free_* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43854 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
| How to convert all 3d references to normal references in a workboo | Excel Worksheet Functions | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Linear Mode
