if...then

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=SUMPRODUCT((A1:A100="")*(B1:B100="YES"))
=SUMPRODUCT((A1:A100="MILK")*(B1:B100="COFFEE"))
you can build these things pretty wide:
=SUMPRODUCT((A1:A100="MILK")*(B1:B100="COFFEE")*(C1:C100>=TODAY())*(D1:D100=
"BEN"))

HTH. Best wishes Harald
 
Back
Top