Help with SUMIF formula

  • Thread starter Thread starter Iriemon
  • Start date Start date
I

Iriemon

Trying to get SUMIF formula to sum the values between D:1602 & D2620 if they
are greater than .15 but less than 1.65. Unfortunately, the formula below is
giving me zero for the result. (AB1 = .15, AB2 = 1.65). The idea is to be
able to change the min and max in AB 1 & 2 and have it sum only those cells
between the values)

=SUMIF(competition!D1602:D2620,OR(competition!D1602:D2620>AB1,competition!D1602:D1620<AB2))

Thanks for any help!

Irie
 
if they are greater than .15 but less than 1.65

I guess you know that you're excluding both 0.15 and 1.65 from the
calculation?

One way:

=SUMIF(competition!D1602:D2620,">"&AB1)-SUMIF(competition!D1602:D1620,">="&AB2)
 
Forgot the last argument:

=Sumproduct((competition!D1602:D2620>AB1)*(competition!D1602:D2620<AB2)*competition!D1602:D2620)
 
Back
Top