Values to Letters?? Possible?

[DarklyCute1]

My boss has lately given me a new project an absence report for human resources. It has 8 categories (sick, personal, vacation, funeral leave, professional leave, jury duty, a.w.o.l., and worker's comp) thereare 70 employees and each has to be recorded each day. (mon-fri).
Now that there's the background. Is there a way to give a letter a value? Say I enter V for vacation can I get the program to recognize it as a value of 1 then have all the v's total elsewhere? Sorry if that's confusing, but if anyone has any ideas, it would be much appreciated.

DarklyConfused

[Scoops]

DarklyCute1 wrote:
> My boss has lately given me a new project an absence report for human
> resources. It has 8 categories (sick, personal, vacation, funeral
> leave, professional leave, jury duty, a.w.o.l., and worker's comp)
> thereare 70 employees and each has to be recorded each day. (mon-fri).
>
> Now that there's the background. Is there a way to give a letter a
> value? Say I enter V for vacation can I get the program to recognize
> it as a value of 1 then have all the v's total elsewhere? Sorry if
> that's confusing, but if anyone has any ideas, it would be much
> appreciated.

Hi DarklyCute1

Yes there is but it'll be easier to try:

=COUNTIF(A1:A10,"=V")

Amend the range to yours and amend the "=V" to whatever other letters
you use.

Regards

Steve

[DRANDON]

Try some variation of this:

# Of Employees out for Vacation
@COUNTIF(A1:A70="Vacation")

# Of Employees out Sick
@COUNTIF(A1:A70="Sick")

Ect...

[Carmel]

Using the countif function would assign a value of 1 to each occurence of "V" for vacation. But how about if you only wanted it to have a value of .50? for a half day....???

[Gord Dibben]

Assign .5 to another letter or combination of letters like HD for half-day


Gord Dibben MS Excel MVP

On Fri, 30 Jun 2006 11:56:29 -0500, Carmel
<[email protected]> wrote:

>
>Using the countif function would assign a value of 1 to each occurence
>of "V" for vacation. But how about if you only wanted it to have a
>value of .50? for a half day....???

[DarklyCute1]

Thanks so much to everyone who responded! You're all a great help!