I have two cells on one work sheet that I want to add together in a cell on
another work sheet.
And is it possible to add together two cells on seperate work sheets in a
cell on third work sheet

Hi,
When you say add do you mean sum and different worksheets are different
files? if the answer is yes and let's assume that the worksheet names are A,
B and C and the information is in that sheets in the tab called Sheeet1 and
the information is to be summarize in worksheet C

=+[A]Sheet1!$A$1+[B]Sheet1!$A$2

"lar" wrote:

> I have two cells on one work sheet that I want to add together in a cell on
> another work sheet.
> And is it possible to add together two cells on seperate work sheets in a
> cell on third work sheet

Within worksheets; just mention the sheet name and the cell referrnce as below


=Sheet1!C28+Sheet2!D25

--
Jacob (MVP - Excel)


"lar" wrote:

> I have two cells on one work sheet that I want to add together in a cell on
> another work sheet.
> And is it possible to add together two cells on seperate work sheets in a
> cell on third work sheet

What does "add" mean to you?

"SUM" or "combine contents"?

To SUM =Sheet1!A1 + Sheet2!B3

To combine contents

=Sheet1A1 & Sheet2!B3


Gord Dibben MS Excel MVP

On Tue, 27 Apr 2010 07:35:01 -0700, lar <(E-Mail Removed)>
wrote:

>I have two cells on one work sheet that I want to add together in a cell on
>another work sheet.
>And is it possible to add together two cells on seperate work sheets in a
>cell on third work sheet

Eduardo

Maybe you should check out help on the difference between "Worksheet" and
"Workbook"


Gord Dibben MS Excel MVP

On Tue, 27 Apr 2010 08:02:01 -0700, Eduardo
<(E-Mail Removed)> wrote:

>Hi,
>When you say add do you mean sum and different worksheets are different
>files? if the answer is yes and let's assume that the worksheet names are A,
>B and C and the information is in that sheets in the tab called Sheeet1 and
>the information is to be summarize in worksheet C
>
>=+[A]Sheet1!$A$1+[B]Sheet1!$A$2
>
>"lar" wrote:
>
>> I have two cells on one work sheet that I want to add together in a cell on
>> another work sheet.
>> And is it possible to add together two cells on seperate work sheets in a
>> cell on third work sheet

Hi Gord,
I know the difference but I wasn't sure what he try to say, it happens to me
last year somebody giving the same description and was refering to different
workbooks, this is why I asked if he means different files

"Gord Dibben" wrote:

> Eduardo
>
> Maybe you should check out help on the difference between "Worksheet" and
> "Workbook"
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 27 Apr 2010 08:02:01 -0700, Eduardo
> <(E-Mail Removed)> wrote:
>
> >Hi,
> >When you say add do you mean sum and different worksheets are different
> >files? if the answer is yes and let's assume that the worksheet names are A,
> >B and C and the information is in that sheets in the tab called Sheeet1 and
> >the information is to be summarize in worksheet C
> >
> >=+[A]Sheet1!$A$1+[B]Sheet1!$A$2
> >
> >"lar" wrote:
> >
> >> I have two cells on one work sheet that I want to add together in a cell on
> >> another work sheet.
> >> And is it possible to add together two cells on seperate work sheets in a
> >> cell on third work sheet
>
> .
>

But then you used the term "worksheet" names A, B and C with tab called
Sheet1

I guess you meant to say "workbook" names A, B and C


Gord

On Tue, 27 Apr 2010 10:16:04 -0700, Eduardo
<(E-Mail Removed)> wrote:

>Hi Gord,
>I know the difference but I wasn't sure what he try to say, it happens to me
>last year somebody giving the same description and was refering to different
>workbooks, this is why I asked if he means different files
>
>"Gord Dibben" wrote:
>
>> Eduardo
>>
>> Maybe you should check out help on the difference between "Worksheet" and
>> "Workbook"
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Tue, 27 Apr 2010 08:02:01 -0700, Eduardo
>> <(E-Mail Removed)> wrote:
>>
>> >Hi,
>> >When you say add do you mean sum and different worksheets are different
>> >files? if the answer is yes and let's assume that the worksheet names are A,
>> >B and C and the information is in that sheets in the tab called Sheeet1 and
>> >the information is to be summarize in worksheet C
>> >
>> >=+[A]Sheet1!$A$1+[B]Sheet1!$A$2
>> >
>> >"lar" wrote:
>> >
>> >> I have two cells on one work sheet that I want to add together in a cell on
>> >> another work sheet.
>> >> And is it possible to add together two cells on seperate work sheets in a
>> >> cell on third work sheet
>>
>> .
>>