| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Problem in Excel | Excel Worksheet Functions | |||
| A Linking Problem | New Users to Excel | |||
| problem with linking data | Excel Worksheet Functions | |||
| I am stumped on a linking problem... | Excel Discussion (Misc queries) | |||
| Worksheet Linking problem | Excel Discussion (Misc queries) | |||
Linear Mode
