countif condition problem
Try...
=SUMPRODUCT(--(A1:K1=1),--(A2:K2=0))
Note that SUMPRODUCT does not accept whole column references.
Hope this helps!
In article ,
"Scott" wrote:
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
|