Your sample layout or try to count bob for reason 2
=sumproduct((a2:a22="bob")*(b2:b22=2))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PR Kid" wrote in message
...
I have a table that shows all the employees that have been termed. I want
to
count how many different codes each manager has used in a given amount of
time.
ie: bob termed 10 employees using codes 2,3,5,9,12,2,5. what formula can
I
use to show me: two terms code 2, two term code 5 an so on for a total
term
of 7 employees

Have a great day