Thread
:
In excel counting cells in a range which meet condition "Xand<X"
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
Posts: n/a
In excel counting cells in a range which meet condition "Xand<X"
=SUMPRODUCT(--(rngx),--(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)
"Uncivil Servant" <Uncivil
wrote in
message ...
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.
Reply With Quote