Sum up all up changes and down changes
Hi all,
Suppose I have a data series like below
A B
Data Chg
46.1250
47.1250 1.0000
46.4375 -0.6875
46.9375 0.5000
44.9375 -2.0000
44.2500 -0.6875
44.6250 0.3750
45.7500 1.1250
47.8125 2.0625
47.5625 -0.2500
47.0000 -0.5625
Chg is calculated from minusing the preivous data item just above from the
value in the corresponding row.
e.g., First exmaple, Chg of 1.000 is indeed 47.1250 - 46.1250
I want one and ONLY ONE function in a cell to calculate sum of all up
changes (=0) and all down changes (<0) in Chg column, ONLY using Data Column
cells as input to this function.
Can someone help?
Tetsuya
|