cprince,
I tested my solution in cells B29:C45. The results and the formula view are
pasted below. Use an IF function, test the data cell to be added, the only
way there will be no change is if that cell is zero, right? So you tell the
running total formula to print nothing (use empty quotes, "") if the adjacent
cell is equal to zero, and to print the normal running total if the cell
contains a value other than zero.
Please let us know if this answers your question. Thanks.
Data view: (formula view directly below)
B C
29 5 5
30 6 11
31 12 23
32 33 56
33 5 61
34 6 67
35 212 279
36 33 312
37 66 378
38 66 444
39 66 510
40 23 533
41 0
42 0
43 5 538
44 6 544
45 0
Formula view:
B C
29 5 =IF(B29=0,"",SUM($B$29:B29))
30 6 =IF(B30=0,"",SUM($B$29:B30))
31 12 =IF(B31=0,"",SUM($B$29:B31))
32 33 =IF(B32=0,"",SUM($B$29:B32))
33 5 =IF(B33=0,"",SUM($B$29:B33))
34 6 =IF(B34=0,"",SUM($B$29:B34))
35 212 =IF(B35=0,"",SUM($B$29:B35))
36 33 =IF(B36=0,"",SUM($B$29:B36))
37 66 =IF(B37=0,"",SUM($B$29:B37))
38 66 =IF(B38=0,"",SUM($B$29:B38))
39 66 =IF(B39=0,"",SUM($B$29:B39))
40 23 =IF(B40=0,"",SUM($B$29:B40))
41 0 =IF(B41=0,"",SUM($B$29:B41))
42 0 =IF(B42=0,"",SUM($B$29:B42))
43 5 =IF(B43=0,"",SUM($B$29:B43))
44 6 =IF(B44=0,"",SUM($B$29:B44))
45 0 =IF(B45=0,"",SUM($B$29:B45))
