Linking Problem
 

I have tried using the following formula in linking two workbooks. How can I
retrieve information (numbers) from two different cells in the source
workbook? Neither will work.

Formula in cell D8: =[Acct1MAS.xlsx]A!D8+G8
Also tried this formula in D8: =[Acct1MAS.xlsx]A!$D$8,[Acct1MAS.xlsx]A!$G$8

--
Thanks; in advance,
Richard

Linking Problem
 

If they are numbers and you want to add them, try:

=[Acct1MAS.xlsx]A!D8 + [Acct1MAS.xlsx]A!G8

If they are text and you want to concatenate them use & instead of +



"Richard" wrote:

I have tried using the following formula in linking two workbooks. How can I
retrieve information (numbers) from two different cells in the source
workbook? Neither will work.

Formula in cell D8: =[Acct1MAS.xlsx]A!D8+G8
Also tried this formula in D8: =[Acct1MAS.xlsx]A!$D$8,[Acct1MAS.xlsx]A!$G$8

--
Thanks; in advance,
Richard

Linking Problem
 

Thank you, Vergel Adriano. The syntax you gave me worked just great. I tried
several different formulas, but couldn't seem to get it right.
--
Thanks; in advance,
Richard


"Vergel Adriano" wrote:

If they are numbers and you want to add them, try:

=[Acct1MAS.xlsx]A!D8 + [Acct1MAS.xlsx]A!G8

If they are text and you want to concatenate them use & instead of +



"Richard" wrote:

I have tried using the following formula in linking two workbooks. How can I
retrieve information (numbers) from two different cells in the source
workbook? Neither will work.

Formula in cell D8: =[Acct1MAS.xlsx]A!D8+G8
Also tried this formula in D8: =[Acct1MAS.xlsx]A!$D$8,[Acct1MAS.xlsx]A!$G$8

--
Thanks; in advance,
Richard

Linking Problem
 

You want to SUM the two cells or concatenate the two cells.

To sum..........=SUM([Acct1MAS.xlsx]A!$D$8:[Acct1MAS.xlsx]A!$G$8)

To concatenate.......=[Acct1MAS.xlsx]A!$D$8 & [Acct1MAS.xlsx]A!$G$8


Gord Dibben MS Excel MVP



On Sun, 11 Mar 2007 09:21:10 -0700, Richard
wrote:

I have tried using the following formula in linking two workbooks. How can I
retrieve information (numbers) from two different cells in the source
workbook? Neither will work.

Formula in cell D8: =[Acct1MAS.xlsx]A!D8+G8
Also tried this formula in D8: =[Acct1MAS.xlsx]A!$D$8,[Acct1MAS.xlsx]A!$G$8

Linking Problem
 

Thanks, but the first solution worked for what I was wanting to do. I will
keep your syntax in mind if I need to use them in the future.
--
Thanks; in advance,
Richard


"Gord Dibben" wrote:

You want to SUM the two cells or concatenate the two cells.

To sum..........=SUM([Acct1MAS.xlsx]A!$D$8:[Acct1MAS.xlsx]A!$G$8)

To concatenate.......=[Acct1MAS.xlsx]A!$D$8 & [Acct1MAS.xlsx]A!$G$8


Gord Dibben MS Excel MVP



On Sun, 11 Mar 2007 09:21:10 -0700, Richard
wrote:

I have tried using the following formula in linking two workbooks. How can I
retrieve information (numbers) from two different cells in the source
workbook? Neither will work.

Formula in cell D8: =[Acct1MAS.xlsx]A!D8+G8
Also tried this formula in D8: =[Acct1MAS.xlsx]A!$D$8,[Acct1MAS.xlsx]A!$G$8