Summing differences with multpile criteria

  • Thread starter Thread starter TT
  • Start date Start date
T

TT

I want to sum the difference between each row in 2 columns of data for each
case where row(i) in column A > 0 and row(i) in column B is less than column A
 
So which column should be subtracted from which column?

A-B or B-A

Try one of these:

A-B:

=SUMPRODUCT(--(A1:A10>0),--(B1:B10<A1:A10),A1:A10-B1:B10)

B-A:

=SUMPRODUCT(--(A1:A10>0),--(B1:B10<A1:A10),B1:B10-A1:A10)
 
Back
Top