try
=sum(indirect(b17&"2:"&b17&"2000"))

" wrote:

What I am trying to do is something like this. Using B17 which will
return a letter, say G so that this formula (or actually a corrected
version of it!)
=SUM("B17"&2:"B17"&2000)

would give =SUM(G2:G2000)

Could anyone suggest how this can be done,
Thanks,
Barbara