How would i do the following:
I have 2 columns - Column A and Column B. I want to count the number of
'YES' in column B ONLY when Column A is blank.

IE.
Column A Column B
YES
TEST YES
TEST2 NO
YES

I want the result to be 2.

I'm sure my next question is pretty similar:
If this is another spreadsheet Column A and Column B. How do I count all the
'COFFEE' in column B ONLY when column A value is 'MILK'?

IE:
Column A Column B
MLK COFFEE
CREAM RED
TEST2 COFFEE
MILK COFFEE
MILK RED

I want my result to count 2 coffee