Count as ½

L

LC

I am creating a holiday spreadsheet whereby X equals one days' holiday and
X/2 equals a half days holiday. I can't figure out the formula to get the
sheet to count these to get a total of remaining days. I'm not very good
with formulas and I can't make sense of the Help function - so please respond
in very simple terms!!
Thanks so much.
 
B

Bob Phillips

=COUNTIF(rng,"X")+COUNTIF(rng,"X/2")/2

counts the number of holidays

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
M

Mike H

If it isn't too late to change your mind then I really wouldn't start from
here because it would be far simpler to have 1 = 1 holiday and 1/2 = half a
holiday. However if you can't or dont want to do that try:-

=A3-(COUNTIF(A4:A14,"=x")+COUNTIF(A4:A14,"=x/2")/2)

has the number of holiday in A3 and the number taken either x or x/2 in the
range A4 to A14. Change to suit.

Mike
 
Top