If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running Total Column
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. |
#2
|
|||
|
|||
Running Total Column
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 |
Thread Tools | |
Display Modes | |
|
|