How do I take a static number and subtract daily values (or add negative values) until zero? Thanks!
Example:
25,000 - -42 (first value listed from bottom) = 25,042
25,042 - 132 (second value listed from bottom) = 24,910
24,910 - 111 (3rd value listed from bottom) = 24,799
Static number: 25000
Dates and values:
Column A Column B
6/30/2023 64
6/29/2023 105
6/28/2023 108
6/27/2023 127
6/26/2023 133
6/25/2023 0
6/24/2023 178
6/23/2023 136
6/22/2023 32
6/21/2023 99
6/20/2023 67
6/19/2023 45
6/18/2023 -2
6/17/2023 149
6/16/2023 171
6/15/2023 111
6/14/2023 62
6/13/2023 79
6/12/2023 137
6/11/2023 1
6/10/2023 104
6/9/2023 115
6/8/2023 116
6/7/2023 -16
6/6/2023 43
6/5/2023 176
6/4/2023 2
6/3/2023 111
6/2/2023 132
6/1/2023 -42
