Formula How?

[Michael168]

Anyone can help me for the below formula.

Worksheet 1
Col A B C
1 3 5
2 5 2
4 1 3
How to count no of odd numbers in the range A1:C1, A2:C2, A3:C3? I
plain english, I want is if there is a count of 3, the cell value wil
be equal to 1.
As the example above,in worksheet 2, cell B1=1, B2=0, B3=0
I want the answer in worksheet 2,Col B instead of in worksheet 1.

Thanks for helping

 

[Aladin Akyurek]

One way...

In D1 enter & copy down:

=--(SUMPRODUCT(1-(MOD(A1:C1,2)=0))=COUNT(A1:C1))

 

[J.E. McGimpsey]

One way:

Sheet2:

B1: =--(SUMPRODUCT(--(MOD(Sheet1!A1:C1,2)=1))=3)

and copy down.