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

Is that 3 or three?

=SUMPRODUCT(--(A1:A100=3),--(B1:B100="Y")

or

=SUMPRODUCT(--(A1:A100="three"),--(B1:B100="Y")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tim" <[email protected]> wrote in message
news:OgeF%[email protected]...
> 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
>
>