cumulative data in a column

shyamvinjamuri

Board Regular
Joined
Aug 2, 2006
Messages
174
I have Yesterday's date in column A, Today's data in column B. Column C has difference between column A and column B. Some days data changes many times a day.
How to put cumulative data in column D only when column C changes?

eg.
Today
10 in column A, 6 in column B, so column C is 4.
Tomorrow
column A is 25 column B is 20, so column C is -5.

I like to have column D showing -1 and so on every time I update the data in columns A and B. Column D should change only when values in column C change.

Please help.

Thanks
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,836
Office Version
  1. 365
Platform
  1. Windows
Do you mean something like this?

If your data starts in row 2,
then enter this in the following cells:
D2: = C2
D3: =IF(C3<>0,D2+C3,"")

and copy the formula in D3 down for all rows
 

Watch MrExcel Video

Forum statistics

Threads
1,112,937
Messages
5,543,095
Members
410,583
Latest member
gazz57
Top