=SUMPRODUCT(--(J1: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