CUMULATIVE SUM
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
--
sherry
|