=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