Hi - need formula that will count in one column based on condition in another
column.

For Instance - if column A has "Blue" , I want to check column B and if it
has "Y" I want to count the number of "Y"'s (associated with Blue)

Thanks for your help in advance. ct