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