COUNTIF Problem

**Jackster** · 11-07-2006, 05:40 AM

Hi
I'm setting up a spreadsheet to calculate people's holidays. So far for each person I have a formula for counting the number of days a 'H' is input for holiday which is =COUNTIF(B2:AF2,"H") which is fine for counting full days, but I need a formula for counting half days so that if HH is input it will count the number of times it is input but add half each time.
I hope this makes sense.
Please help!!!
Thanks
Jackie

**davesexcel** · 11-07-2006, 05:44 AM

=COUNTIF(B2:AF2,B1)

this example has B1 as the criteria you want to count

**Bryan Hessey** · 11-07-2006, 06:35 AM

Originally Posted by Jackster

Hi
I'm setting up a spreadsheet to calculate people's holidays. So far for each person I have a formula for counting the number of days a 'H' is input for holiday which is =COUNTIF(B2:AF2,"H") which is fine for counting full days, but I need a formula for counting half days so that if HH is input it will count the number of times it is input but add half each time.
I hope this makes sense.
Please help!!!
Thanks
Jackie

=COUNTIF(B2:AF2,"H")+(COUNTIF(B2:AF2,"HH"))/2

should work
---