I have a spreadsheet that contains a list of data points over time, along with some time values that denote events. I want to sum all the data points between each of the event values.
My spreadsheet looks something like this:
The index of the cell closest to the event I can obtain by using
=MATCH(K13, $B$12:$B$8889, 1) (for example), which returns the index (e.g.
301 as above). However, I don't know how to go from those indicies, which specify a cell, to the sum of a series.
The value I can swipe with something like
=INDEX($G$12:$G$8889,M13), but I don't want just the one value, I want to sum everything between, say, 1 (aka
B12) and 301 (