Remember Me?

#1
March 13th 05, 10:57 PM
 Bill O'Neal Posts: n/a
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.

#2
March 13th 05, 11:15 PM
 Ragdyer Posts: n/a

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

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.

#3
March 14th 05, 02:02 AM
 CLR Posts: n/a

=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

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.

#4
March 14th 05, 09:27 PM
 John Britto Posts: n/a

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.

#5
March 16th 05, 12:55 PM
 Bill O'Neal Posts: n/a

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.

#6
September 4th 08, 07:06 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2008 Posts: 1
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.

#7
September 5th 08, 12:19 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,909
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.

#8
August 14th 09, 11:27 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 1
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?

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.

#9
August 14th 09, 11:36 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
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:
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post notloiseweiss Excel Discussion (Misc queries) 7 February 18th 08 01:15 AM williejoeshaver Excel Discussion (Misc queries) 1 March 11th 05 09:44 PM Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM Destiny Excel Worksheet Functions 2 November 20th 04 03:17 AM BD7447 Excel Worksheet Functions 1 November 6th 04 05:41 PM

All times are GMT +1. The time now is 08:02 AM.