ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CUMULATIVE SUM (https://www.excelbanter.com/excel-discussion-misc-queries/205857-cumulative-sum.html)

Sherry

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


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com