Hello Cliff,
welcome to the forum. Try this in H5:Formula:
=SUM(--(N5:AS5="Sick")*--(N2:AS2<>"Sun")*--(N2:AS2<>"Sat"))/2
Let me know if it works.
Cheers
Hello Cliff,
welcome to the forum. Try this in H5:Formula:
=SUM(--(N5:AS5="Sick")*--(N2:AS2<>"Sun")*--(N2:AS2<>"Sat"))/2
Let me know if it works.
Cheers
<-- If you're happy & you know it...click the star.:-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks