Creating Range based on Cell Names in other Cells

I have a table (A1:F10), wherein all cells have numbers.
Now, I want to find the SUM of all the numbers which is a simple =SUM(A1:F10). But the twist is in Cell J1, I will write lets say B3, and in K1, I write D9.
Based on this input , I want to find the sum of the range (B3:D9). So in cell J1, I have the start of the range and K1, I have the end of the range.

Therefore the normal formula would be SUM(B3:D9). Thus, this B3 and D9 are contents of J1 and K1 respectively.

How do I write a formula to get this done : SUM(content of J1 : content of K1).

I hope this is possible.

You can use INDIRECT for that..

=SUM(INDIRECT(J1 & ":" & K1))


However, I'm curious exactly how B3 and D9 will get into those 2 cells ?
Are you typing them by hand, or do you have some other formula that is creating those references ?

Typing them manually..

Worked like a charm.. Thanks a lot Jonmo1....

You're welcome.