I'd like to sum up values of specific cells in a column (In this case column A) from bottom to top, in order to get the latest added values, until they match a specific value (if greater than zero) from another cell (in this case 7 as noted in Cell A1). If they match that value, I'd like to have a sum of the cells next to column A.
In the example below, I'd like to start summing up from cell A7 upwards, since the cells below are empty. So it keeps going up one row until the sum equals a predefined value (in this case: 7 as noted in Cell A1).
So if A7, A6 and A5 match 7, I'd like to see the sum the sum of cells B7, B6 and B5. In the example below, the sum of values in the B column should thus be 8
Row | Column A | Column B | Column C 1 | 7 | | Total: 8 2 | | | 3 | 8 | 1 | 4 | 3 | 2 | 5 | 4 | 3 | 6 | 2 | 3 | 7 | 1 | 2 | 9 | [empty] | [empty] | 10 | [empty] | [empty] | 11 | [empty] | [empty] |
I hope the above is clear, and I am very curious if this can be done.