Hello,
I am keeping an attendance at work and I have to total the workers Sick days. I currently have two Total lines:
1 Total line that sums up the accumulated FULL sick days: =COUNTIF(D9:D269,"S") and the other
1 Total line that sums up the accumulated HALF sick days =COUNTIF(D9:D269,".5S")
I would like to only have one Total line, therefore, is there a way and what formula do I have to use in the TOTAL cell to add up days in half days too? I tried =SUM(COUNTIFS(D9:D269,{"S",".5S"})) but this adds full days only.
Thank you.
Felix
Bookmarks