=SUMPRODUCT(--(J2:J100="employee number"),L2:L100)


"Curtis" wrote:

Column J= employee number
Column L = day(s) work

I need to sum the number of different days worked by each employee (Column L
can have multiple instances of the same date)

Thanks

ce