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]

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 occurenc
of "V" for vacation. But how about if you only wanted it to have
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

 

[DarklyCute1]

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