Excel - cell address inside formula as text from other cell

[kris.krzysiek]

Hi

Have problem with inserting cell address inside formula

If we use formula wizard to make simple sum from cell A1 to A2, our
formula on formula window looks like(independ of language version of
course ):

=SUM(A1:A2)

I want to put inside formula cell adresses, which are put as text on
some other cells, for expl:

cell B1=A1, (as text)
cell B2=A2, (as text)

now need to prepare function like:
SUM(here_value_from_B1:here_value_from_B2)
I tried on many ways but without success

Any ideas?

Greetings Kris

 

[Bernard Liengme]

Try =SUM(INDIRECT(B1&":"&B2))
best wishes

 

[Gary''s Student]

=SUM(INDIRECT(B1&":"&B2))

 

[kris.krzysiek]

Big THX, now it works!

 

[Bruce Sinclair]

Try =SUM(INDIRECT(B1&":"&B2))
best wishes

As an aside, can you do something similar with 'cell names' or not ?

Thanks

 

[RagDyer]

Try this:

=SUM(INDIRECT(B1):INDIRECT(B2))