Count Between Ranges

Posted by Blair on August 08, 2001 7:43 AM

How do you count the number of values in a column that
lie BETWEEN two values? I have been trying COUNTIF but
it only seems to allow one range criteria.
In this case I need the number of values between
>=7.5 and &LT;10.

Any help much appreciated.

Posted by Barrie Davidson on August 08, 2001 9:07 AM

I would recommend using an IF statement in an adjacent column and then adding up that.

Hope this helps you out.

Barrie

Posted by Aladin Akyurek on August 08, 2001 11:26 AM

Alternatively: use either of

(1) =SUMPRODUCT((A1:A100>=7.5)*(A1:A100&LT;10))

(2) =SUM((A1:A100>=7.5)*(A1:A100 &LT; 100))

The second needs to be array-entered, that is, you need to hit CONTROL+SHIFT+ENTER at the same time (not just ENTER) to enter it.

Aladin

Posted by Barrie Davidson on August 08, 2001 11:51 AM

Aladin, I knew you'd come up with an array solution...

I tried it on my own but couldn't quite get it. Array formulas are a difficult concept to get my head around but I can really see where they would come in handy. Anyways, I still working on getting better in this area.

Regards,
Barrie