Can Excel have a VARIABLE Cell Reference???

[Rolls100]

I cannot figure out how to have a variable ina cell reference.

Say cell A4 contains a text character of "H".
I want
=SUM(H6:N6) to be able to be replaced by =SUM((A4)6:N6)

I hope I have not missed anything obvious - but I cannot get this to work in any way shape form or fashion.

I would also like to be able to replace the row number with an integer variable - cannot get that to work either.

Thanks ahead of time for any help,
Royce

[Domenic]

Try the following...

=SUM(INDIRECT(A4&A5):N6)

...where A4 contains the text character refering to the column and A5 contains the number refering to the row.

Hope this helps!

I cannot figure out how to have a variable ina cell reference.

Say cell A4 contains a text character of "H".
I want
=SUM(H6:N6) to be able to be replaced by =SUM((A4)6:N6)

I hope I have not missed anything obvious - but I cannot get this to work in any way shape form or fashion.

I would also like to be able to replace the row number with an integer variable - cannot get that to work either.

Thanks ahead of time for any help,
Royce