Count if a number is between X and Y

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WBTKbeezy - 17 Nov 2005 20:50 GMT

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?

Reply to this Message

Jezebel - 17 Nov 2005 20:58 GMT

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

>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?

Reply to this Message

Bob Phillips - 17 Nov 2005 20:58 GMT

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

Signature

HTH

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

> 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?

Reply to this Message

bpeltzer - 17 Nov 2005 21:02 GMT

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

> 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?

Reply to this Message