CUMULATIVE SUM

[sherry]

Hi All,

I'm trying to add a row of numbers, (some blank cells) and I only want it to
add when there is a number to add. In other words:

A1= 4 B1=2, I would like to have "6" in C1, but if there is a blank in D1,
I would like the 6 to appear again. If there is a 1 in E1, I would the the
formula to add the 6 from D1 and replace the 1 in E1 with a "7". I don't
want the cells to add up like 6+1+7. I don't want a running total, I want a
(I'm thinking cumulative).

thank you so much,
sherry

 

[Sean Timmons]

So, does that mean you want somethign like this:

In B2, =A1+B1
In C2, =B2+C1
Copy formula from C2 across the row...

 

[Sean Timmons]

And as I read your post again, assuming you DON'T want the above.

 

[sherry]

Yes, thank you it worked, but you wanted me to move all my data out of the
way and start with a clean area and change the cell references to accommodate
my data, right? Doing it exactly the way you said, I got circular references
and don't know how to "keep" the circular references (or if I can?) and still
make my values work. I've never been able to.

So after my realization of needing to tweak the formula to my specs. it
works fine. thanks for getting back to me so quickly!!