Excel - cell address inside formula as text from other cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kris.krzysiek@gmail.com - 29 Jan 2008 13:17 GMT

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

Reply to this Message

Bernard Liengme - 29 Jan 2008 13:52 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi
>
[quoted text clipped - 19 lines]
>
> Greetings Kris

Reply to this Message

kris.krzysiek@gmail.com - 29 Jan 2008 14:50 GMT

Big THX, now it works!

On 29 Sty, 14:52, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:

> Try =SUM(INDIRECT(B1&":"&B2))
> best wishes
> --
> Bernard V Liengme

Reply to this Message

Bruce Sinclair - 29 Jan 2008 23:38 GMT

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

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

Thanks

Reply to this Message

RagDyer - 30 Jan 2008 00:58 GMT

Try this:

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>>Try =SUM(INDIRECT(B1&":"&B2))
>>best wishes
>
> As an aside, can you do something similar with 'cell names' or not ?
>
> Thanks

Reply to this Message

Gary''s Student - 29 Jan 2008 13:59 GMT

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

Signature

Gary''s Student - gsnu2007c

Reply to this Message