Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:

Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami