Count yes against name

[Dave]

Hi. I have a spreadsheet with a list of client names in column A that are
duplicated throughout the column dependent if they have bought products and a
statement saying either yes or no in column B. In a second sheet I have the
list of individual clients and I would like to count the amount of yes's or
no's against each client in the first sheet.

How do I do this?

Thanks

 

[Jacob Skaria]

In Sheet1 B2 enter the below formula which will count the number of Yes and
No in Sheet2 for the client mentioned in Sheet1 A2

=SUMPRODUCT(--(Sheet2!A2:A1000=A2),--ISNUMBER(MATCH(Sheet2!B2:B1000,{"Yes","No"},0)))

If this post helps click Yes