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

count 1 cell in column based on value in another cell
 

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" wrote in message
...
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