=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)



"LC" wrote in message
...
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.