D28 is entered daily & cell has no formula
E28 is =D28-D27 (copied down page)
F28 is =E28/D28 (copied down page)

Day total Day increase Percentage
----------+---------------+-------------
(D28) (E28) (F28)
1215.02 6.74 0.005547234
----------+---------------+-------------
(D29) (E29) (F29)
1231 15.98 0.012981316
----------+---------------+-------------
D29 is entered daily & cell has no formula
E29 is D29-D28 (copied down page)
F29 is E29/D29 (copied down page)



But in the next line & lines before I enter a # in the D colum cell I get
this...
I need to keep the formula and remove the data shown and from being totaled
in E columb... can this be done?

(D30) (E30) (F30)
-1231 #DIV/0!

D30 is to entered the next day but I need to total the E columb without the
Negitive # in the cell...