ExcelBanter - Counting Text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting Text (https://www.excelbanter.com/excel-worksheet-functions/446824-counting-text.html)

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?

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2