count from drop down list

[sn699]

I have a problem with counting from drop down lists when two option matches.
I have many rows and in each row there are two drop down lists like in the picture:

in each list I have 10 different options (YES,NO,IDK and more)
I want to sum the number of times the user chose the same option like in the pictures, if in row 3 option1 is "NO" and option2 is also "NO" it should be 1.
if option1 is different from option2 it should be 0 (like in rows 5 and 6).
I don't know what formula can I use to do that 1/0 values to appear (I want to put it in c3 to c7).
Hope you can help me, Thanks.

 

[VoG]

Try in C3 copied down

=IF(B3=A3,1,0)

 

[sn699]

Try in C3 copied down

=IF(B3=A3,1,0)

Thanks it worked.
Now I need also to count the number of times the user choose the option "no" in option1 and "YES" in option 2 like in row 5 in the picture.
The formula will be in another cell (in the D column)

 

[VoG]

Try

=SUMPRODUCT(--(A3:A100="NO"),--(B3:B100="YES"))

 

[sn699]

thank you very much