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:
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...