Hi there,
You want he INDIRECT() function, like this...
HTHCode:=SUM(INDIRECT("R"&A1&":R"&A2))
I would like to compute the sum of a variable contiguous part of the range R(1:1000) where say cells A1 and A2 contain the integers indicating the first and the last cell of the selected part respectively. For instant is A1 contains 7 and A2 contains 120 how can I compute SUM(R7:R120)? Thanks for the help.
Hi there,
You want he INDIRECT() function, like this...
HTHCode:=SUM(INDIRECT("R"&A1&":R"&A2))
Regards,
Zack Barresse
If you want to avoid the volatile INDIRECT also tryCode:=SUM(INDEX($R$1:$R$1000,A1):INDEX($$R1:$R$1000,A2))
Bookmarks