Making a letter equal 1 formula

[Randy]

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

[Biff]

Hi!

Try this:

=COUNTIF(A1:A10,"V")

Biff

"Randy" <[email protected]> wrote in message
news:[email protected]...
>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

[Randy]

Either I did something wrong or it does not work. I entered this formula in a
cell. I then Typed 'V', but nothing showed up in my totals.

"Biff" wrote:

> Hi!
>
> Try this:
>
> =COUNTIF(A1:A10,"V")
>
> Biff
>
> "Randy" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>

[Randy]

OOPS! My bad.... I think I got it. Thanks!

"Biff" wrote:

> Hi!
>
> Try this:
>
> =COUNTIF(A1:A10,"V")
>
> Biff
>
> "Randy" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>