COUNTIF Function between 2 values

[Donna]

I can get the COUNTIF function to work for greater than or
less than a value, but cannot figure out the syntax to
COUNTIF values are between a certain RANGE. Help!

 

[Aladin Akyurek]

One of:

=COUNTIF(Range>=Low)-COUNTIF(Range>High)

=SUMPRODUCT(--(Range>=Low),--(Range<=High))

 

[Dave R.]

A common solution for this is to countif the first bound then subtract the
other bound, leaving you what's inbetween them, like;

countif(a1:a100,">100")-countif(a1:a100,"<150")

will count numbers from a1-a100 that are from 101 through 149.

 

[J.E. McGimpsey]

Two ways:

Say you want to count values in Column A between 50 and 100,
inclusive (i.e., entries of 50 and 100 would both be counted).

=COUNTIF(A:A,">=50") - COUNTIF(A:A, ">100")

or

=SUMPRODUCT(--(A1:A65535>=50),--(A1:A65535 <=100))

(you can't use entire columns in Sumproduct().

 

[Dave R.]

Whoops, make that 101 through 150.

A common solution for this is to countif the first bound then subtract the
other bound, leaving you what's inbetween them, like;

countif(a1:a100,">100")-countif(a1:a100,"<150")

will count numbers from a1-a100 that are from 101 through 149.