Multiple conditions in a COUNTIF

[John]

How do I do a set up the fcn to count all cells in a range that are >0% and
<25%?

 

[AG]

How do I do a set up the fcn to count all cells in a range that are >0% and
<25%?

Hi John,
Try using this: SUMPRODUCT((cellrange>0)*1,(cellrange<0.25)*1)
Regards,
-AG

 

[Bob Phillips]

=COUNTIF(A:A,">0")-COUNTIF(A1:A20,">=.25")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

That was meant to be

=COUNTIF(A:A,">0")-COUNTIF(A:A,">=.25")


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Teethless mama]

=SUM(COUNTIF(A:A,{">0",">=0.25"})*{1,-1})

 

[Catenary]

=COUNTIF(A:A,">0")-COUNTIF(A:A,">=.25")

This won't do the trick. It subtracts the count of all values less than
0.25 from the count of all values greater than 0. It's not the same as the
number of all values between 0 and 0.25.

I've tried

=COUNTIF(A:A, AND(">0","<0.25))

but that returns 0 since it is evaluating whether a value is "TRUE".

 

[T. Valko]

=COUNTIF(A:A,">0")-COUNTIF(A:A,">=.25")

This won't do the trick It subtracts the count of all
values less than 0.25 from the count of all values
greater than 0. It's not the same as the number of
all values between 0 and 0.25.

No, it literally counts all values **between** 0 and 0.25.

It counts all numbers >0 then subtracts the count of all numbers >=0.25.

So, the range is in essence (out to 15 decimal places):

0.000000000000001
0.249999999999999

 

[Ashish Mathur]

Hi,

Did you try

=sumproduct((A5:A500>0)*(A5:A500<=0.25))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com