Good morning all. I'm currently working on a attendance tracker, I have a
formula that will give us either half or full occurrence. Before we didnt
need to track 0 but now we have. I tried to change the formula to give us a
full occurrence (1) but Im getting an error. Can anyone help me with this€¦
Thanks

=(COUNTIF(L9:BF9,"0")-COUNTIF(L9:BF9,"=5"))+((COUNTIF(L9:BF9,"=5")-COUNTIF(L9:BF9,"=8"))/2)


--
Regards
YM