software

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

=SUMPRODUCT(--(rnggt;x),--(rnglt;y))

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

=SUMIF(rng,quot;lt;gt;quot;amp;x)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Uncivil Servantquot; lt;Uncivil gt; wrote in
message ...
gt; I'm trying to construct a formula that will count the number of cells in a
gt; range that meet the condition quot;gt;x and lt;xquot;, (which I suppose is two
conditions
gt; in one really), where the range just contains numbers.