Excel: Cumulative Total with Blank Cells


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!

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


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 02, 2014.


For more resources for Microsoft Excel