Hello Cliff,

welcome to the forum. Try this in H5:
Formula: copy to clipboard
=SUM(--(N5:AS5="Sick")*--(N2:AS2<>"Sun")*--(N2:AS2<>"Sat"))/2


Let me know if it works.

Cheers