Counting text

[Andy P]

I have a calendar in a worksheet with spaces beside each day of the year to
input peoples initials if they are on leave that day.
So I use the following formula for counting the number of leave days they
have per month =COUNTIF(N238,"CK")

I would also like to include on the calendar, half days leave, e.g. I would
type in CK½ or CK1/2 (either one would be fine), using something like:

=COUNTIF(N238,"CK½") or =COUNTIF(N238,"CK1/2")

But this counts them as full days. is there any way to have the formula sum
up all the occurances of "CK½" in a range, but count them as 0.5 of a day?

e.g. "CK" occurs in the range 3 times, and "CK½" occurs once, the formula
result should be 3.5

Thanks

 

[T. Valko]

=COUNTIF(N238,"CK½") or =COUNTIF(N238,"CK1/2")

Just divide the result by 2:

=COUNTIF(N238,"CK½")/2

=COUNTIF(N238,"CK1/2")/2

 

[FSt1]

hi
just devide the half count by 2.

=COUNTIF(N238,"CK1/2")/2

regards
FSt1