Most valuable professional
  • Hot Topics

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 8000 4000 2000 7000 3000 9000 10000 200 2000 5000 892 108 75 200

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

This thread is current as of November 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel