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


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=557354

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

Try some variation of this:

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

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

Ect...


--
DRANDON
------------------------------------------------------------------------
DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901
View this thread: http://www.excelforum.com/showthread...hreadid=557354

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....???


--
Carmel
------------------------------------------------------------------------
Carmel's Profile: http://www.excelforum.com/member.php...o&userid=35951
View this thread: http://www.excelforum.com/showthread...hreadid=557354

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
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....???

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


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=557354