concatenate in a cell and using that cell value
Posted by Boumy on November 26, 2001 6:09 PM
say I have an array in column A10:A5000
A1 = A
A2 = 400
A3 = A1&A2 =A400
I want to sum now by having
sum(A3:A500) where A3 is really A400
Posted by Juan Pablo G. on November 26, 2001 6:28 PM
You have to use the INDIRECT function.
Try this:
=SUM(INDIRECT(A3&":A500"))
Juan Pablo G.
