using cell reference in a formula
 

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

using cell reference in a formula
 

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

using cell reference in a formula
 

Hi Barbara,

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

HTH
Martin


wrote in message
ups.com...
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

using cell reference in a formula
 

In . com,
spake thusly:

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"))

--
dman

using cell reference in a formula
 

Thanks guys that worked exactly how I needed it.
Barbara

wrote in message
ups.com...
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