![]() |
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