| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
