Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums
data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#2
|
|||
|
|||
You can work around this type of syntax:
=SUM(Sheet2!A1:A2) =SUM(Sheet2!A2,Sheet2!E2,Sheet2!A4,Sheet2!E5:E8) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bill O'Neal" <Bill wrote in message ... I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#3
|
|||
|
|||
=SUM('C:\My Documents\[Workbook2.xls]Sheet1'!A1:A3) Vaya con Dios, Chuck, CABGx3 "Bill O'Neal" <Bill wrote in message ... I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#4
|
|||
|
|||
You can simply use the sum formula or just link each cell starting with =
sign then + the cell reference + cell reference and so on.. John Britto "Bill O'Neal" wrote: I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#5
|
|||
|
|||
I found that for the cell in Worksheet 1, where the various cells from
Worksheet 2 were to be added, I wrote "=SUM(" and clicked on all the cells in Worksheet 2 that needed to be consolidated, and Excel did the rest. Thanks for showing me the way. "Bill O'Neal" wrote: I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
Lets say I have a big column of data. In this case it data taken every 15 min.
I want to turn this into data every hour so I must sum 4 cells at a time and end up with this data in a column. The issue is that if i do this with formulas and then try to extrapolate it down then lets say my new column looks like this Sum(Sheet2!A1:A4) Sum(Sheet2!A5:A8) Sum(Sheet2!A9:A12) Ect. Then if I try to drag this down the new cells are Sum(Sheet2!A2:A5) Sum(Sheet2!A3:A6) Sum(Sheet2!A4:A7) Sum(Sheet2!A6:A9) Sum(Sheet2!A7:A10) Sum(Sheet2!A8:A11) Ect This second set of data is not what I am looking for and I dont know how to do this with out entering in 800 formulas. any ideas? "Bill O'Neal" wrote: I found that for the cell in Worksheet 1, where the various cells from Worksheet 2 were to be added, I wrote "=SUM(" and clicked on all the cells in Worksheet 2 that needed to be consolidated, and Excel did the rest. Thanks for showing me the way. "Bill O'Neal" wrote: I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
Enter this in A1 of Sheet1
=SUM(INDEX(Sheet2!A:A,ROW(A1)*4-3):INDEX(Sheet2!A:A,ROW(A1)*4)) Drag/copy down as far as you need. Gord Dibben MS Excel MVP On Thu, 4 Sep 2008 11:06:13 -0700, the_damnit wrote: Lets say I have a big column of data. In this case it data taken every 15 min. I want to turn this into data every hour so I must sum 4 cells at a time and end up with this data in a column. The issue is that if i do this with formulas and then try to extrapolate it down then lets say my new column looks like this Sum(Sheet2!A1:A4) Sum(Sheet2!A5:A8) Sum(Sheet2!A9:A12) Ect. Then if I try to drag this down the new cells are Sum(Sheet2!A2:A5) Sum(Sheet2!A3:A6) Sum(Sheet2!A4:A7) Sum(Sheet2!A6:A9) Sum(Sheet2!A7:A10) Sum(Sheet2!A8:A11) Ect This second set of data is not what I am looking for and I don’t know how to do this with out entering in 800 formulas. any ideas? "Bill O'Neal" wrote: I found that for the cell in Worksheet 1, where the various cells from Worksheet 2 were to be added, I wrote "=SUM(" and clicked on all the cells in Worksheet 2 that needed to be consolidated, and Excel did the rest. Thanks for showing me the way. "Bill O'Neal" wrote: I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
RD's answer was helpful, but I found I had to use inverted single quotes
around the name of the worksheet. "Bill O'Neal" wrote: I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
Yes, you have to put single quotes around the sheet name if it includes
spaces. -- David Biddulph HRG wrote: RD's answer was helpful, but I found I had to use inverted single quotes around the name of the worksheet. "Bill O'Neal" wrote: I'm using Excel 2002, trying to create a budget (say, workbook 1) that sums data from a second workbook (workbook 2). There may be 3 or 4 cells in workbook 2 (each one the sum of a column of figures) that I would like to add together and enter in a single cell in workbook 1. Using the Consolidate command in the Data menu, I can link one cell from workbook 2 to a cell in workbook 1, but I can't get two or more workbook 2 cells to be added into a single cell in workbook 1. I'm sure there's an elementary solution to this. Could someone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
Sorting mixed up linked cells in a workbook? | Excel Worksheet Functions | |||
Delete contents of unprotected cells in workbook | Excel Worksheet Functions |