Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if...then
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 |