Count yes against name
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
---------------
Jacob Skaria
"Dave" wrote:
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
|