Counting Text

[LIST GURU]

HI, SO I HAVE COLUMN A, with 5 varying names (spanning about 100 cells)
then column b contains either yes or no..(based on response) is there
formula that i can use to create an output cell for each name, whic
counts the yes and no response for each of the 5 names

 

[Claus Busch]

Hi,

Am Sat, 11 Aug 2012 17:27:14 +0000 schrieb LIST GURU:

HI, SO I HAVE COLUMN A, with 5 varying names (spanning about 100 cells)
then column b contains either yes or no..(based on response) is there a
formula that i can use to create an output cell for each name, which
counts the yes and no response for each of the 5 names?

try:
=COUNTIFS(A2:A100,"Name1",B2:B100,"yes")
or
=SUMPRODUCT(--(A2:A100="Name1"),--(B2:B100="yes"))

or use PivotTable, that's easier


Regards
Claus Busch