Help with SUMIF formula

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
 
T

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!D1602:D2620,">"&AB1)-SUMIF(competition!D1602:D1620,">="&AB2)
 
R

RagDyer

Forgot the last argument:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top