Count if a number is between X and Y
 

I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?

Count if a number is between X and Y
 

In another column insert the test formula: =AND(A1250, A1<2000), then count
the number of cells in that column containing TRUE.





"WBTKbeezy" wrote in message
...
I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?

Count if a number is between X and Y
 

=COUNTIF(A:A,"<2000")-COUNTIF(A:A,"<250")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"WBTKbeezy" wrote in message
...
I need a fucntion that allows me to count if in a range of numbers how
many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?

Count if a number is between X and Y
 

You could get there with sumproduct, but countif can handle it in two steps:
=countif(a:a,"250")-countif(a:a,"=2000").

"WBTKbeezy" wrote:

I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?