Build a Cell Reference
Build a Cell Reference
(OP)
I know we've talked about this before, but I just can't find it in eng-tips or in Excel help.
Cell J12 = 498
Cell K12 = 559
I want cell L12 to be SUM(C498:C559)
Using simple concatenation (ampersand) I can get C498:C559 but when I put a SUM() around it I get #VALUE. I had high hopes for INDIRECT, but it just gave me the contents of C498, a colon, and the contents of C559.
I know this is easy, and I know I've seen it discussed here, but I just can't figure out what to call the functionality I need.
David
Cell J12 = 498
Cell K12 = 559
I want cell L12 to be SUM(C498:C559)
Using simple concatenation (ampersand) I can get C498:C559 but when I put a SUM() around it I get #VALUE. I had high hopes for INDIRECT, but it just gave me the contents of C498, a colon, and the contents of C559.
I know this is easy, and I know I've seen it discussed here, but I just can't figure out what to call the functionality I need.
David





RE: Build a Cell Reference
AN alternative approach would be to use offset, I think.
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Build a Cell Reference
Alternatively put ="C"&J12&":C"&K12 in L12 then
=SUM(INDIRECT(L12))
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Build a Cell Reference
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Build a Cell Reference
That is exactly the step I was missing. Thank you.
David