Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert cell into link
i have a link to another program and want to change the code (see agl) in the
formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks |
#2
|
|||
|
|||
i also want another link such as ='[copy 2Share
Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks |
#3
|
|||
|
|||
now i want to sum values in column H only if the corresponding cell in column
F = 1 thanks again and again and again "Micayla Bergen" wrote: i also want another link such as ='[copy 2Share Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks |
#4
|
|||
|
|||
There's an =sumif() function that you'll want to check out in Excel's help.
Debra Dalgleish also has some instructions at: http://www.contextures.com/xlFunctions01.html#SumIf Micayla Bergen wrote: now i want to sum values in column H only if the corresponding cell in column F = 1 thanks again and again and again "Micayla Bergen" wrote: i also want another link such as ='[copy 2Share Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks -- Dave Peterson |
#5
|
|||
|
|||
Thanks Dave
Can you also help w the formula for referring to another spreadsheet? What i am trying to do is update a share price automatically by referring to the code in col A, then update a share rating by referring to the same code and getting the information from a cell in the same row but different col. Thanks "Dave Peterson" wrote: There's an =sumif() function that you'll want to check out in Excel's help. Debra Dalgleish also has some instructions at: http://www.contextures.com/xlFunctions01.html#SumIf Micayla Bergen wrote: now i want to sum values in column H only if the corresponding cell in column F = 1 thanks again and again and again "Micayla Bergen" wrote: i also want another link such as ='[copy 2Share Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks -- Dave Peterson |
#6
|
|||
|
|||
I'm not sure I understand the question well enough. But are you looking for
something like: =vlookup()? Micayla Bergen wrote: Thanks Dave Can you also help w the formula for referring to another spreadsheet? What i am trying to do is update a share price automatically by referring to the code in col A, then update a share rating by referring to the same code and getting the information from a cell in the same row but different col. Thanks "Dave Peterson" wrote: There's an =sumif() function that you'll want to check out in Excel's help. Debra Dalgleish also has some instructions at: http://www.contextures.com/xlFunctions01.html#SumIf Micayla Bergen wrote: now i want to sum values in column H only if the corresponding cell in column F = 1 thanks again and again and again "Micayla Bergen" wrote: i also want another link such as ='[copy 2Share Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
yes
"Dave Peterson" wrote: I'm not sure I understand the question well enough. But are you looking for something like: =vlookup()? Micayla Bergen wrote: Thanks Dave Can you also help w the formula for referring to another spreadsheet? What i am trying to do is update a share price automatically by referring to the code in col A, then update a share rating by referring to the same code and getting the information from a cell in the same row but different col. Thanks "Dave Peterson" wrote: There's an =sumif() function that you'll want to check out in Excel's help. Debra Dalgleish also has some instructions at: http://www.contextures.com/xlFunctions01.html#SumIf Micayla Bergen wrote: now i want to sum values in column H only if the corresponding cell in column F = 1 thanks again and again and again "Micayla Bergen" wrote: i also want another link such as ='[copy 2Share Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks -- Dave Peterson -- Dave Peterson |
#8
|
|||
|
|||
If you need to learn more about =vlookup(), you can read Excel's Help.
And read Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html Micayla Bergen wrote: yes "Dave Peterson" wrote: I'm not sure I understand the question well enough. But are you looking for something like: =vlookup()? Micayla Bergen wrote: Thanks Dave Can you also help w the formula for referring to another spreadsheet? What i am trying to do is update a share price automatically by referring to the code in col A, then update a share rating by referring to the same code and getting the information from a cell in the same row but different col. Thanks "Dave Peterson" wrote: There's an =sumif() function that you'll want to check out in Excel's help. Debra Dalgleish also has some instructions at: http://www.contextures.com/xlFunctions01.html#SumIf Micayla Bergen wrote: now i want to sum values in column H only if the corresponding cell in column F = 1 thanks again and again and again "Micayla Bergen" wrote: i also want another link such as ='[copy 2Share Recommendations.xls]Stocks'!$D$235 where A5 in my current speadsheet has the same value in the copy 2sharerec spreadsheet as say cell B5 thanks "Micayla Bergen" wrote: i have a link to another program and want to change the code (see agl) in the formula to cell A5 but am not sure of the applicable brackets or = signs or " or , =DFS|Quotes!agl.L/100 Many thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link the worksheet tab to a cell in the worksheet? | Excel Worksheet Functions | |||
Problems with hyperlinks | Excel Discussion (Misc queries) | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
How do I link an identical cell address across multiple worksheet. | Excel Worksheet Functions |