Problem:

Numbers Range (A2:C6) contains numbers.
Columns E & F contain pairs of cell references that indicate the beginning and end of parts of Numbers Range that we wish to sum.
We want to create formulas to calculate the sum for each specified sub-range.
Solution:

Use the SUM and INDIRECT functions as shown in the following formula:
=SUM(INDIRECT(E2&\":\"&F2))