If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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? 
Ads 
#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? 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Updating linked cells within a workbook, from worksheet to workshe  notloiseweiss  Excel Discussion (Misc queries)  7  February 18th 08 01:15 AM 
How do I save an Excel workbook so that cells referencing another.  williejoeshaver  Excel Discussion (Misc queries)  1  March 11th 05 09:44 PM 
Protecting Workbook  Paul Cooling  Excel Discussion (Misc queries)  2  March 7th 05 11:55 AM 
Sorting mixed up linked cells in a workbook?  Destiny  Excel Worksheet Functions  2  November 20th 04 03:17 AM 
Delete contents of unprotected cells in workbook  BD7447  Excel Worksheet Functions  1  November 6th 04 05:41 PM 