How Many in one column based on the value in another column

[cheryl27284]

In column A I have employee id's, in column B I have Yes or no. There are hundreds of records. I want to know how many "no's" each employee has. For example. Employee 114 has 100 "No's". I just want the total to appear in a table beside each employee ID. What formula do I use?

 

[GrayShades]

Assume that you have an employee ID in C3, then use this formula in D3:

=SUMPRODUCT(($A$1:$A10=C3)*($B$1:$B$10="no"))

Software: XL2002 on Win2K
Humanware: Older than dirt

 

[Zathras]

Create a pivot table.

Put employee number as ROW,
put answer as COLUMN,
put Count of Employee as DATA
and voila.

Look up "pivot table" in the help file for more details.