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




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 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? 
#7




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)*43):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




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




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 