Multiple conditions in a COUNTIF

Thread view:

Thread rating:

John - 24 May 2008 00:37 GMT

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

AG - 24 May 2008 00:47 GMT

> 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 - 24 May 2008 00:53 GMT

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

Signature

---
HTH

Bob

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

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

Bob Phillips - 24 May 2008 01:03 GMT

That was meant to be

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

Signature

---
HTH

Bob

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

> =COUNTIF(A:A,">0")-COUNTIF(A1:A20,">=.25")
>
>> How do I do a set up the fcn to count all cells in a range that are >0%
>> and
>> <25%?

Teethless mama - 24 May 2008 03:03 GMT

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

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