Count yes against name

D

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top