count 1 cell in column based on value in another cell

I have a table that looks like the following

one Y
one
two
two
three Y
three Y
three

What I am trying to do is count the numbers of Y's based on the value in the
first column


ie......count y's if column 1 = 3

Thanks
Tim