using cell reference in a formula

[barb24]

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

 

[Guest]

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

 

[MartinW]

Hi Barbara,

Try
=SUM(INDIRECT(B17&"2:"&B17&"2000"))

HTH
Martin

 

[Dallman Ross]

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)

This would be one way:

=SUM(INDIRECT(B17&"2:"&B17&"2000"))

 

[Guest]

Thanks guys that worked exactly how I needed it.
Barbara