Double indirect

[Peter100]

I'm wanting to create a SUM(xx:xx) with both sides of the : being selected from the cell contents of A1 & B1 ie.
If A1 contained the value C7
and
B1 contained the value C50

The SUM(xx:xx) would calculate the sum of C7 to C 50

I (with the thanks of "Jminskey") can now calculate it with one variable using =SUM(INDIRECT(A1&":C50")) but how can I make the second part ie. the C50 be read from B1

 

[cfree36]

=SUM(INDIRECT(A1):INDIRECT(B1))

 

[fairwinds]

..or:

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

 

[Peter100]

I feel a right plxxxxr as usual I was trying the obscure route and ignoring the obvious

Thank you

 

[Aladin Akyurek]

I feel a right plxxxxr as usual I was trying the obscure route and ignoring the obvious

Thank you

And your first question doesn't require INDIRECT...