Help with SUMIF formula

[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!D16022620,OR(competition!D16022620>AB1,competition!D16021620<AB2))

Thanks for any help!

Irie

 

[T. Valko]

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!D16022620,">"&AB1)-SUMIF(competition!D16021620,">="&AB2)

 

[RagDyer]

Try this:

Sumproduct((competition!D16022620>AB1)*(competition!D16022620<AB2))

 

[RagDyer]

Forgot the last argument:

=Sumproduct((competition!D16022620>AB1)*(competition!D16022620<AB2)*competition!D16022620)