Hello Group Excel,

I am using Excel 2003.

My computation Columns are "E" to "J", and starts on Row 15.

Column "I" is the Total.

Column "J" is the Running Total.

With the following data:

E F G H I J

..12 2.12 .09 -3.25 -.92 -.92

..08 1.99 .03 -2.99 -.89 -1.81

..10 2.05 .07 -3.15 -.93 -2.74

((In the "J" Column when there is no)) -2.74
((amount in Columns "E" to "I",))
((through Row 42 shows the last total.)) -2.74

-2.74

-2.74


After the final total of -2.74, how can I
eliminate subsequent amounts of -2.74
from appearing in the Running Total
Column, until I get to the 42nd Row
that will show the grand total?

Thank you for your help in this matter.