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.

 HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK?

#1
March 13th 05, 10:57 PM
 Bill O'Neal external usenet poster 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 external usenet poster 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 external usenet poster 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 external usenet poster 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 external usenet poster 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
 the_damnit external usenet poster 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
 Gord Dibben external usenet poster 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
 HRG external usenet poster 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
 David Biddulph[_2_] external usenet poster 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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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

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