Help with SUMIF formula
 

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!D160 2:D2620AB1,competition!D1602:D1620<AB2))

Thanks for any help!

Irie

Help with SUMIF formula
 

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)


--
Biff
Microsoft Excel MVP


"Iriemon" wrote in message
...
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!D160 2:D2620AB1,competition!D1602:D1620<AB2))

Thanks for any help!

Irie

Help with SUMIF formula
 

Try this:

Sumproduct((competition!D1602:D2620AB1)*(competit ion!D1602:D2620<AB2))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Iriemon" wrote in message
...
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!D160 2:D2620AB1,competition!D1602:D1620<AB2))

Thanks for any help!

Irie

Help with SUMIF formula
 

Forgot the last argument:

=Sumproduct((competition!D1602:D2620AB1)*(competi tion!D1602:D2620<AB2)*competition!D1602:D2620)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
Try this:

Sumproduct((competition!D1602:D2620AB1)*(competit ion!D1602:D2620<AB2))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Iriemon" wrote in message
...
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!D160 2:D2620AB1,competition!D1602:D1620<AB2))

Thanks for any help!

Irie