Counting text
 

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(N2:P38,"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(N2:P38,"CK½") or =COUNTIF(N2:P38,"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

Counting text
 

=COUNTIF(N2:P38,"CK½") or =COUNTIF(N2:P38,"CK1/2")

Just divide the result by 2:

=COUNTIF(N2:P38,"CK½")/2

=COUNTIF(N2:P38,"CK1/2")/2

--
Biff
Microsoft Excel MVP


"Andy P" <Andy wrote in message
...
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(N2:P38,"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(N2:P38,"CK½") or =COUNTIF(N2:P38,"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

Counting text
 

hi
just devide the half count by 2.

=COUNTIF(N2:P38,"CK1/2")/2

regards
FSt1

"Andy P" wrote:

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(N2:P38,"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(N2:P38,"CK½") or =COUNTIF(N2:P38,"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