This I didn't think would be hard, but is causing me quite the headache. I have data in one column (Net Amount) that has double spaces after every few lines. In another column, I want to keep a cumulative total, but not include those spaces in the cumulative total column (I have been able to run cumulative total, but is places the same number 3 times in a row because of the empty cells in the first column). Does anyone have a function that can achieve what I mirrored below (instead of manually adding it like I did)? Thanks!
<tbody>
</tbody>
Net Amount | Cumulative Total |
8000 | 8000 |
4000 | 12000 |
2000 | 16000 |
7000 | 23000 |
26000 | |
35000 | |
3000 | 45000 |
9000 | 45200 |
10000 | 47200 |
200 | 52200 |
2000 | 53092 |
5000 | 53200 |
53275 | |
53475 | |
892 | |
108 | |
75 | |
200 |
<tbody>
</tbody>