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

On May 24, 7:37*am, John wrote:
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((cellrange0)*1,(cellrange<0.25)*1)
Regards,
-AG

=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)



"John" wrote in message
...
How do I do a set up the fcn to count all cells in a range that are 0%
and
<25%?

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)



"Bob Phillips" wrote in message
...
=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)



"John" wrote in message
...
How do I do a set up the fcn to count all cells in a range that are 0%
and
<25%?

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


"John" wrote:

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

"Bob Phillips" wrote:

=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".

=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


--
Biff
Microsoft Excel MVP


"Catenary" wrote in message
...


"Bob Phillips" wrote:

=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".

Hi,

Did you try

=sumproduct((A5:A5000)*(A5:A500<=0.25))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Catenary" wrote in message
...


"Bob Phillips" wrote:

=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".