Counting text

  • Thread starter Thread starter Andy P
  • Start date Start date
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(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
 
=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
 
Back
Top