Countif on 2 different rows
 

I have 2 different rows with different values in 6 columns set up as such


Row 1: 110010
Row 2: 502345

I am trying to write a formula to count the instances where row 2 is 0 and
row 1 = 1

So in this instance, row 2 0 in all but the second column (column B); row
1 = 1 in columns A, C and E

Therefore, the total could be 2 b/c both criteria are meant in column A and E

Help?

Countif on 2 different rows
 

=SUMPRODUCT(--(A1:Z1=1),--(A2:Z20))


--


Regards,


Peo Sjoblom


"kd5000" wrote in message
...
I have 2 different rows with different values in 6 columns set up as such


Row 1: 110010
Row 2: 502345

I am trying to write a formula to count the instances where row 2 is 0
and
row 1 = 1

So in this instance, row 2 0 in all but the second column (column B);
row
1 = 1 in columns A, C and E

Therefore, the total could be 2 b/c both criteria are meant in column A
and E

Help?

Countif on 2 different rows
 

Try this:

=SUMPRODUCT(--(A1:F1=1),--(A2:F20))

--
Biff
Microsoft Excel MVP


"kd5000" wrote in message
...
I have 2 different rows with different values in 6 columns set up as such


Row 1: 110010
Row 2: 502345

I am trying to write a formula to count the instances where row 2 is 0
and
row 1 = 1

So in this instance, row 2 0 in all but the second column (column B);
row
1 = 1 in columns A, C and E

Therefore, the total could be 2 b/c both criteria are meant in column A
and E

Help?