formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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!
=====================================================


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
 
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
 
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
 
Back
Top