Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count yes against name
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |