Ahh, the ever popular SUMPRODUCT!

=SUMPRODUCT((A2:A5000="Blue")*(B2:B5000="Y"))

Please note, cannot use entire column (A:A), and both ranges must match
(2-5000, or 2 - 100, or whatever)

"Cindyt" wrote:

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