In excel counting cells in a range which meet condition ">Xand<X"

U

Uncivil Servant

I'm trying to construct a formula that will count the number of cells in a
range that meet the condition ">x and <x", (which I suppose is two conditions
in one really), where the range just contains numbers.
 
B

Bob Phillips

=SUMPRODUCT(--(rng>x),--(rng<y))

if it is really two values, but if as you show then

=SUMIF(rng,"<>"&x)

--

HTH

Bob Phillips

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