Hi!

Try this:

=COUNTIF(A1:A10,"V")

Biff

"Randy" wrote in message
...
I am setting up a vacation spraedsheet for work. Is there a way to enter V
for vacation day and have it equal one in my totals. I want to
differentiate
vacation days from sick days for each employee. I have all the necessary
formulas set up to automatically deduct days if I enter the number 1, but
I
would rather enter V and have it equal the number 1. Hope this makes
sense.....Thanks