Teethless mama formula did it ,Thank you guys

"Sheeloo" wrote:

Enter in D2 and copy down...
=Sumproduct(--(A$2:A$1000=A2),--(C$1:C$100=C2),--(B$2:B$100))
[You will get the count multiple times for the same combination]
Change 100 to the end of you data set...

"MAANI" wrote:

This is what I have:
A (Date) B (Emp #) C (Product #)
10-Oct-08 2 700
10-Oct-08 3 710
11-Oct-08 3 700
12-Oct-08 1 702
12-Oct-08 1 700
12-Oct-08 2 700
12-Oct-08 2 700
12-Oct-08 2 740

I want a formula to count how many employees worked on a certain product in
a certain day . Example: on 12-Oct-08,2 employees worked on product #
700.Thanks