Thread: CUMULATIVE SUM
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sherry Sherry is offline
external usenet poster
 
Posts: 116
Default 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