countif using cell references in criteria

[Hall]

Can I use cell references in criteria of the function countif? Can I do
this using a boolean function?

Here's what I want:

=countif( A1:A100, and( >B1, < C1 ) )

ie, count only if the number in the range is between the numbers in b1 and
c1.

 

[Bob Phillips]

You can

=COUNTIF(A1:A100,">"&B1)

but you cannot have two conditions

=SUMPRODUCT(--(A1:A100>B1),--(A1:A100<C1))

--

HTH

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

 

[Hall]

Excellent! Thanks!

You can

=COUNTIF(A1:A100,">"&B1)

but you cannot have two conditions

=SUMPRODUCT(--(A1:A100>B1),--(A1:A100<C1))

--

HTH

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