Counting based on multiple criteria

I have two columns that have drop down boxes with either a Yes or a No as the only inputs. I need to be able enter a formula that counts up the total "No" inputs in one column but count it up only if the other column says yes. Any suggestions.

If you can Concatenate the two into the next column, you could then count the NoYes entries in that column.