Prev: Formula help
Next: How can I lookup when match has more than one value?
From: Eduardo on 27 Apr 2010 13:16
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
> <Eduardo(a)discussions.microsoft.com> 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
>
> .
>
From: Gord Dibben on 27 Apr 2010 13:54
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
<Eduardo(a)discussions.microsoft.com> 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
>> <Eduardo(a)discussions.microsoft.com> 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
>>
>> .
>>

 | 
Pages: 1
Prev: Formula help
Next: How can I lookup when match has more than one value?