Reference cell range parameter from other cell dynamically in excel

Question

I've got a simple range based formula

=SUM(A3:A$5)

I would like to dynamically assign the range value in the formula by referencing another cell's value, for example

cell B1 = 3 and cell B2 = 5

=SUM(A<referenced value from B1>:A$<referenced value from B2>)

Is it possible?

Answer 1

Yes, use the INDIRECT function

=SUM(INDIRECT("A"&B1&":A"&B2))

Note: I haven't tested this formula, let me know if there are any problems

Answer 2

Using INDEX works too.

=SUM(INDEX(A:A,B1):INDEX(A:A,B2))

Referencing an earlier answer which suggests using this method instead of INDIRECT.