Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to create a workbook of several worksheets that sum different
things and have one worksheet that displays all of the totals. I.e: Have Worksheet A, Worksheet B, Worksheet C each calculate totals and then have the totals carried over to Worksheet D. How would I do this? |
#2
![]() |
|||
|
|||
![]()
click onto the cell in D where you want the total from A to show. enter =
and go to the cell on A and click onto the cell with the total. press enter .............done one.........etc Regards Bill K "mjohnson0321" wrote in message ... I would like to create a workbook of several worksheets that sum different things and have one worksheet that displays all of the totals. I.e: Have Worksheet A, Worksheet B, Worksheet C each calculate totals and then have the totals carried over to Worksheet D. How would I do this? |
#3
![]() |
|||
|
|||
![]()
Hi, mjohnson0321;
Select a cell cell on Worksheet D where you want a total from Worksheet A to appear, type =, switch to Worksheet A, select the cell containing the total you want, and click the green checkmark in the formula bar. You will be returned to Worksheet D, which will now hold a formula like ='Worksheet A'!A1 which will repeat the contents of cell A1 in Worksheet A. Another way: select a cell in Worksheet A that contains a total, copy, switch to Worksheet D, right-click the cell you want to paste into, choose Paste Special Paste Link. This will paste a formula like ='Worksheet A'!$A$1 giving the same result only with an absolute cell reference rather than a relative one. Regards. IanRoy. "mjohnson0321" wrote: I would like to create a workbook of several worksheets that sum different things and have one worksheet that displays all of the totals. I.e: Have Worksheet A, Worksheet B, Worksheet C each calculate totals and then have the totals carried over to Worksheet D. How would I do this? |
#4
![]() |
|||
|
|||
![]()
Let's say I would want to copy the total from WorksheetA which is in A10 to
WorksheetD in A10, the total from WorksheetB in B10 to WorksheetD in B10, and the total from WorksheetC in C10 to WorksheetD in C10. I would write the formula in 1. WorksheetD A10 as =IF(ISBLANK(+WorksheetA!A10);"";+WorksheetA!A10) 2. WorksheetD B10 as =IF(ISBLANK(+WorksheetB!B10);"";+WorksheetB!B10) 3. WorksheetD C10 as =IF(ISBLANK(+WorksheetC!C10);"";+WorksheetC!C10) The formula makes sure that if the total is blank there will be no zero appearing in the corresponding cell in WorksheetD, otherwise it copies the totals to the corresponding cells. Swisse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy excel worksheet into msword with row, column headings and gr. | Excel Discussion (Misc queries) | |||
copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Copy data into a NEW worksheet | Excel Discussion (Misc queries) | |||
how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) |