Hi!

Assume your layout is as follows:

A2:An = Type
B2:Bn = Product
C2:Cn = Res_Num
D2:Dn = Emp_Num

G2:Gn = list of unique Res_Num's

Enter this formula in H2 and copy down as needed:

=CEILING(SUMPRODUCT((A$2:A$9={"B","C"})*(B$2:B$9=" R5")*
(C$2:C$9=G2)/COUNTIF(D$2:D$9,D$2:D$9)),1)

Biff

-----Original Message-----
I have a real challenge. I am trying to summarize a large
data set.
I need to determine the number of different employees
involved in delivering
service per specific reservation, if the service type and
product match
criteria.

Sample data:
type product res_num emp_num
A IA 3 50
B IA 2 60
B R5 1 60
B R5 1 60
B R5 2 60
B R5 2 80
B R5 2 80
C IA 3 40

If type = B or C
And if product = R5

Calculate number of different emp_num utilized per res_num

Sample result:
Res_num Different emp_num
1 1
2 2

Is there a formula(s) that will do this?

Thanks

.