Excel - cell address inside formula as text from other cell

K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top