Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif that can i half
I was wondering if anyone could help with a formula I have a holidday
spreadsheet that tracks employees holidays and sick throughout the year at work. I have a colum that counts the number of holidays ane employee taske but I am not sure how to count half days can any one help my formula is below =COUNTIF(M6:GL6,"Bh")+(COUNTIF(M23:GK23,"Bh"))=COU NTIF(M6:GL6,"Bh")/0.05 thanks -- N/A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif that can i half
You say you have a column but you reference M6:GL6
Please tell us the exact layout of the worksheet: employees name in A2 holidays taken in M2:GL2 using the code Bh and half holidays in .......... etc -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Joel" wrote in message ... I was wondering if anyone could help with a formula I have a holidday spreadsheet that tracks employees holidays and sick throughout the year at work. I have a colum that counts the number of holidays ane employee taske but I am not sure how to count half days can any one help my formula is below =COUNTIF(M6:GL6,"Bh")+(COUNTIF(M23:GK23,"Bh"))=COU NTIF(M6:GL6,"Bh")/0.05 thanks -- N/A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using countif function to add only a half of a number | Excel Discussion (Misc queries) | |||
Countif, then multiply?? | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |