Two columns match count formula

Ninfreak

I am trying to create a formula that can match two columns

For instance

Column 1 name column 2 =yes  

Kelly Moore

Hey @Ninfreak

I'm happy to help. What would you like to do with the two matched columns? Are you wanting to

1) IF(AND(Column1="name", Column2 = "yes"), do something?

or

2) COUNTIFS([column1]:[column1], "name", [column2]:[column2], 1)

or 3) something else?

Kelly