Home 
Search 
Today's Posts 
#1




Cell addressing using the content of another cell.
Hi there,
I will like to specify a function e.g. SUM to act on a cell whole address in the content of another cell. For instance, I want to sum Cell A12, and Ax and Ax where x is the content of cell B12 for example. How do I reference a cell with the content of another cell. My task for requiring this is because I want to do the following: Sum B12, B13, B14, B15.... Bxy to cell B4 The end of the B column to sum depends on the value in cell C2 for instance. So if C2 contained 3, then, the sum function will be limited to SUM B12 and B13, and B14 only. Then my result will be SUM (B4, B12:B14) in another cell where the function resides Likewise, had cell C2 contained 2, then my sum resuly would be SUM(B4, B12:B13) Thanks for your response. 
#3




That should read
=SUM(B4,INDIRECT("B12:B"&11+C2))  HTH RP (remove nothere from the email address if mailing direct) "De Jandon" <De wrote in message ... Hi there, I will like to specify a function e.g. SUM to act on a cell whole address in the content of another cell. For instance, I want to sum Cell A12, and Ax and Ax where x is the content of cell B12 for example. How do I reference a cell with the content of another cell. My task for requiring this is because I want to do the following: Sum B12, B13, B14, B15.... Bxy to cell B4 The end of the B column to sum depends on the value in cell C2 for instance. So if C2 contained 3, then, the sum function will be limited to SUM B12 and B13, and B14 only. Then my result will be SUM (B4, B12:B14) in another cell where the function resides Likewise, had cell C2 contained 2, then my sum resuly would be SUM(B4, B12:B13) Thanks for your response. 
#4




or
=SUM(B4,OFFSET(B12,,,C2)) "Bob Phillips" wrote: That should read =SUM(B4,INDIRECT("B12:B"&11+C2))  HTH RP (remove nothere from the email address if mailing direct) "De Jandon" <De wrote in message ... Hi there, I will like to specify a function e.g. SUM to act on a cell whole address in the content of another cell. For instance, I want to sum Cell A12, and Ax and Ax where x is the content of cell B12 for example. How do I reference a cell with the content of another cell. My task for requiring this is because I want to do the following: Sum B12, B13, B14, B15.... Bxy to cell B4 The end of the B column to sum depends on the value in cell C2 for instance. So if C2 contained 3, then, the sum function will be limited to SUM B12 and B13, and B14 only. Then my result will be SUM (B4, B12:B14) in another cell where the function resides Likewise, had cell C2 contained 2, then my sum resuly would be SUM(B4, B12:B13) Thanks for your response. 
#5




Hi Bob,
I tried the functuion but it was always coming up with Excel function error comment window. Is the syntax you gave correct? the BE in the syntax, what is the E refering to? Thanks "Bob Phillips" wrote: =SUM(B4,INDIRECT("B12:BE"&11+C2))  HTH RP (remove nothere from the email address if mailing direct) "De Jandon" <De wrote in message ... Hi there, I will like to specify a function e.g. SUM to act on a cell whole address in the content of another cell. For instance, I want to sum Cell A12, and Ax and Ax where x is the content of cell B12 for example. How do I reference a cell with the content of another cell. My task for requiring this is because I want to do the following: Sum B12, B13, B14, B15.... Bxy to cell B4 The end of the B column to sum depends on the value in cell C2 for instance. So if C2 contained 3, then, the sum function will be limited to SUM B12 and B13, and B14 only. Then my result will be SUM (B4, B12:B14) in another cell where the function resides Likewise, had cell C2 contained 2, then my sum resuly would be SUM(B4, B12:B13) Thanks for your response. 
#6




Thanks Duke,
this solved it. I have asked Bob Phillips to shed more light on the syntax for the INDIRECT function as it was giving error message when i enter the syntax as he suggested. If that works too, then it will be nice to know two ways of solving same problem. Cheers "Duke Carey" wrote: or =SUM(B4,OFFSET(B12,,,C2)) "Bob Phillips" wrote: That should read =SUM(B4,INDIRECT("B12:B"&11+C2))  HTH RP (remove nothere from the email address if mailing direct) "De Jandon" <De wrote in message ... Hi there, I will like to specify a function e.g. SUM to act on a cell whole address in the content of another cell. For instance, I want to sum Cell A12, and Ax and Ax where x is the content of cell B12 for example. How do I reference a cell with the content of another cell. My task for requiring this is because I want to do the following: Sum B12, B13, B14, B15.... Bxy to cell B4 The end of the B column to sum depends on the value in cell C2 for instance. So if C2 contained 3, then, the sum function will be limited to SUM B12 and B13, and B14 only. Then my result will be SUM (B4, B12:B14) in another cell where the function resides Likewise, had cell C2 contained 2, then my sum resuly would be SUM(B4, B12:B13) Thanks for your response. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Cell addressing using the content of another cell.  Excel Worksheet Functions  
Macro on cell content  New Users to Excel  
Footnote wizard linked to cell content  Excel Worksheet Functions  
Indexing / Cell Addressing  Excel Discussion (Misc queries)  
GET.CELL  Excel Worksheet Functions 