Hi,

Thank you for giving me the fomular. I really appreciate for your help.
However, it doesn't work. I enterred U/2 in the cell, the result was 1. I
hope that if I enterred U/2 in the cell, the result will be 1/2 instead of 1.
Please help.

Thanks
Chi

"RagDyeR" wrote:

You'll need another reference for the half day ... so use something like
"U/2".

Then try this:

=COUNTIF(B10:AF10,"U")+COUNTIF(B10:AF10,"U/2")/2

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Chi" wrote in message
...
I really have no clues. I hope I can use the same worksheet for full day
off.

I need another fomular for half day off, but I don't know how to update the
formula (= COUNTIF($B10:$AF10,"U") so that I will work for the hald day
off.

Please give me some ideas or weblinks so that I can learn.
Thanks
Chi

"JE McGimpsey" wrote:

How are you designating a half-day off in your worksheet?

In article ,
Chi wrote:

Hi,

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

I use letter â?oUâ? 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