Hello Group Excel,

I am using Excel 2003.

My computation Columns are "E" to "J".

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.

On Sun, 7 Feb 2010 12:18:23 -0500, "DisMusBeDaPlaz"
wrote:

Hello Group Excel,

I am using Excel 2003.

My computation Columns are "E" to "J".

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.


Try the following formula in cell J1:

=IF(OR(ROW()=42,NOT(ISBLANK(I1))),SUM(I$1:I1),"")

Copy down in column J until cell J42.

Hope this helps / Lars-Åke