A
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
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