countif condition problem
Thanks for clearing that up.
"Peo Sjoblom" wrote:
It's because blank cells return zero when evaluated thus to avoid blank
cells skewing the result when 0 is a condition one can either
check for number like in
=ISNUMBER(Range)
or not empty
=Range<""
--
Regards,
Peo Sjoblom
"Kleev" wrote in message
...
Rather than speculate, I will ask, why do you need the 2:2<""? I tried
this
out, and found you do need it (if there is a 1 in row 1,) but if I say
anything else, I will be speculating.
"Bob Phillips" wrote:
=SUMPRODUCT(--(1:1=1),--(2:2=0),--(2:2<""))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Scott" wrote in message
...
I am working with two rows of data, I want to count the number of
times
that
both rows are equal to a value I specify. Something like this
COUNTIF(1:1,
AND(1:X="1", 2:X="0")). Given the table below, the formula should be
equal
to
two.
A B C D E F G H I J K
1 0 0 1 0 0 1 0 0 1 0 1
2 1 0 0 1 0 1 0 0 0 1 1
--
Scott Miller
University of Washington
Chemistry
|