Hi,

I used COUNTIF function to create an attendance-tracking sheet.

I use letter €œU€� for Unplanned Absence. If I enter U, U, and U, then the
number 3 will appear in the formula cell: = COUNTIF($B10:$AF10,"U").

There is no problem with the formula if the employee takes full day off.
However, the problem comes when the employee takes a half- day off. What
formula I should use if the employee takes a half day off ?

Please help

Thank you
Chi