"Newfie809" wrote:
Hi Max, I tried that one also and it returns a grand total of the count
for all employees and not for each employee

It should not. I'm not sure what's happening over there
=COUNTIF('Sick Leave'!$A$6:$A$43618,'Employee List'!B6) ?
should return the count of the number of instances that the particular
employee, ie 'Employee List'!B6, appears within 'Sick Leave'!$A$6:$A$43618

Check/try again?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---