I have a table with dates in column A and values in column B.
A B 1 2020-12-30 1 2 2020-12-31 2 3 2021-01-04 4
Given a DATE, I can LOOKUP the last value before (including) that date:
For example, it returns 2 for both
DATE=2020-12-31. How can I get the sum of all values down to (including) the value found by lookup? That is, I would like to receive 3 in the above example (add up rows 1 and 2).
The rows are sorted by date.