Is this possible?
A1 = "B2"
A2 = "B150"
A3 = "SUM(A1:A2)" - referencing the actual values of those cells?
Please help!
Is this possible?
A1 = "B2"
A2 = "B150"
A3 = "SUM(A1:A2)" - referencing the actual values of those cells?
Please help!
Hi
Try
=SUM(INDIRECT(A2):INDIRECT(A3))
rylo
Hey thanks for the reply, but that results in a "#REF" error. Any other suggestions?
HiOriginally Posted by tonyrice
try this
=SUM(INDIRECT(A1),INDIRECT(A2))
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
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?
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?
what does the
&
take place of in the formula?
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.....
Thanks for your help!
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.....
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)
Bookmarks