Your formula is perfect!!
Thank you so much for your help and your patience!!!
Chi

"Chi" wrote:


I use the fomular below and it works fine. Ex: As soon as I enterred U in
B10, I got 1 showed at AL10 cell where stored the formula (=
COUNTIF($B10:$AF10,"U").

Again, I hope that if I enter U/2 at B10 and then I will get 1/2 showed at
AL 10.

I think that we almost get it!!
Thanks
Chi



"Ragdyer" wrote:

What formula did you use ... *exactly*?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chi" wrote in message
...
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