HELP!!

[Omer]

Hi,

I want Excell to calculate the difference between vaules
in a column(60.07-60.71, 60.00-60.07, 59.67-60.00, etc)
and them give me a sum of all the -VE's

(Answer should be -1.24)

60.71
60.07 -0.64
60.00 -0.07
59.67 -0.33
59.47 -0.2
60.00 0.53

Thanks
omi

 

[Harlan Grove]

I want Excell to calculate the difference between vaules
in a column(60.07-60.71, 60.00-60.07, 59.67-60.00, etc)
and them give me a sum of all the -VE's

(Answer should be -1.24)

60.71
60.07 -0.64
60.00 -0.07
59.67 -0.33
59.47 -0.2
60.00 0.53

One way. If the column of figures on the left were named X, try

=SUMPRODUCT((OFFSET(X,1,0,ROWS(X)-1,1)<OFFSET(X,0,0,ROWS(X)-1,1))
*(OFFSET(X,1,0,ROWS(X)-1,1)-OFFSET(X,0,0,ROWS(X)-1,1)))

 

[Ken Wright]

Or without having to array enter:-

=SUMPRODUCT((A2:A20-A1:A19)*((A2:A20-A1:A19)<0))

 

[Omer]

Thanks a lot