Sum a section of a column starting & ending based on cel references.

[Jonathan Pollard]

Hi all, In the example below I need a formula in C3 that sums a section of column A with the starting row defined by C1 and the end row defined by C2.

So in the example if I wanted to sum A4:A7 I would input 4 in C1 and 7 in C2 so that C3 gives me the sum of that section.

Any help greatly appreciated. 

[Auril]

hi Jonathan. does this work?  =SUM(INDIRECT("A"&$C$1&":A"&$C$2))

[Alexander Ivanov]

@Auril

This is a great solution!

Alternative idea

=SUM(FILTER(A:A,ROW(A:A)>=C1,ROW(A:A)<=C2))

Permanent link https://docs.google.com/spreadsheets/d/1IcK37My4rh-YW6bL39afkZrlTnVbNqvmiDcuVS6GHEo/edit?usp=sharing