|
formula
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 |
formula
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 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 |
formula
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 âœ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 |
formula
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 |
formula
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 |
formula
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 |
formula
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 |
formula
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 |
formula
You're welcome, and thank you for the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Chi" wrote in message ... 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 |
| All times are GMT +1. The time now is 06:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com