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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,521
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,119,235
Messages
5,576,886
Members
412,751
Latest member
ausrollo
Top