|
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 |
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 |
| All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com