Using the values inside a cell as part of a formula/function

[Cascade]

Hello all,

I am looking to use the values inside a cell, as part of the function in another cell.
Is this possible??

The rows in the above picture have been omitted however they start from 1,2,3 ....

So I have the cell references inside of a cell i.e. the value of range("Q2") = E2 ... etc

What I am trying to do is take the values inside of say cell Q2 and Q3 and use them as a range. So ultimately what I am trying to do is to add SUM(E2:E24) but via referencing to cells Q2 and Q3.

I was hoping something like SUM(Values(Q2):Values(Q3)) would work, but no cigar unfortunately.

Any help would be great.

 

[VoG]

Try

=SUM(INDIRECT(Q2&":"&Q3))

 

[Cascade]

Try

=SUM(INDIRECT(Q2&":"&Q3))

Amazing!
Any explanation on how it works?
I know what the "INDIRECT" function does, but why did you use &":"&
??

Thank you so much.

 

[VoG]

That just generates the colon to give

SUM(E2:E24)