# Can I use this situation?

1. ## Can I use this situation?

Is this possible?

A1 = "B2"
A2 = "B150"

A3 = "SUM(A1:A2)" - referencing the actual values of those cells?

2. Hi

Try

=SUM(INDIRECT(A2):INDIRECT(A3))

rylo

3. Hey thanks for the reply, but that results in a "#REF" error. Any other suggestions?

4. Originally Posted by tonyrice
Hey thanks for the reply, but that results in a "#REF" error. Any other suggestions?
Hi
try this
=SUM(INDIRECT(A1),INDIRECT(A2))

5. I appreciate the knowledgeable response. I think this one is a little trickier, but it's the real problem.....

A1='Build Request Time Sheet'!A2
A2='Build Request Time Sheet'!A100

A3=SUM(INDIRECT(A1):INDIRECT(A2))

This does not work. Any help?

6. Hello tony, I thought this would work

=SUM(INDIRECT(A1&":"&A2))

but when I tested it didn't......although it will work if A1 remains the same but A2 is just

A100

does that help?

7. what does the

&

take place of in the formula?

8. The & concatenates

so

If A1 contains just A5 and A2 just A10

=INDIRECT(A1&":"&A2)

concatenates A1 with ":" with A2 giving you

A5:A10

This works OK with simple cell refs but the 2 sheet names seemed to cause a problem.....

But, its not working when you reference a cell in a different sheet using indirect when summing numbers. I wonder if there is a way.....

10. ## You try this tony!

Hello Tonyrice!

I've checked with the following and works well. You can also try and find out.
in A1: Sheet2!B2
in A2: Sheet2!B150

in Sheet2!B2:25
in Sheet2!B15:250

and entered in Sheet1!A3:SUM(INDIRECT(A1):INDIRECT(A2)

I got in Sheet1!A3:275 !!!

Thanks for your posting & Regards.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1