simple count or sum function??

[Looker]

does any one know how to simply, count the amount of times there is a
condition where two seperate colums have two different anwsers, i.e

from C10 to C20 "Yes" and in D10 to D20 "Selected", and all others can
be ignored, to count the amount tof times they match up in the same
row?????

please help im not very good @ excel

 

[Cesar Zapata]

use the countif function.

for example to count "Selected"

=COUNTIF(E9:E17,"Selected")