Formula

  • Thread starter Thread starter omer
  • Start date Start date
O

omer

Hi,

I want Excell to calculate the difference between vaules
(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)

What is wrong with this formula in Column "L"??
=SUMPRODUCT((L78:L7122-L77:L7122>0)*(L77:L7122<>"")*
(L78:L7122<>"")*(L78:L7122-L77:L7122))

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


Thanks
Omer
 
All ranges must be the same size.

=SUMPRODUCT((L78:L7122-L77:L7121>0)*(L77:L7121<>"")*(L78:L7122<>"")*(L78:L7122-L77:L7121))

Jerry
 
Back
Top