Counting text

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
 
T

T. Valko

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top