I'd like to have a running total in column B based on previous row in B and adjustment amount in A. This simple application can run just on =SUM(B1,A2) and would be copied down the range to evaluate appropriate reference cells.
A B 0 1 1 2 3 3 6
If my filter result hides row 3 for instance (with data A:2, B:3), I need the row 4 in column B to read 4 instead of 6. I'd like the data in row 3 to be disregarded but rest of the running total to continue. I've looked into SUBTOTAL function but it seems that would not be applicable here?
Any suggestions appreciated. Thanks
Bookmarks