HELP!!

  • Thread starter Thread starter Omer
  • Start date Start date
O

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
 
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
Click to expand...

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)))
 
Back
Top