I wonder if something like this will fix the issue??

This is supposed to be an array formula but is just returning N/A at the moment, not sure what I have done wrong or if it will work

{=SUM(IF(SICKRECORD!$A$4:$A$65536=A2,IF(SICKRECORD!$N$4:$N$65536="Sickness",SICKRECORD!E:E>=STAFF!Q2,SICKRECORD!$L$4:$L$65536)))}