In Google Docs, I am trying to sum the values of selected rows in a table, from position START to END.
Imagining this sample data:
Index VALUE
1 300
2 400
3 750
4 850
5 900
6 1000
And two cells where I input START and END:
3
5
I would like the result to be the sum of columns from value: 750 + 850 + 900
I am trying to use SUMIF(range,criteria,sum_range)
but cannot seem to specify a way to use 'between(min, max)' as criteria...