Hello..I am creating a worksheet for the work schedule for X number of
employees. I have the worksheet arranged so that if someone has a day
off a value of "o" is inserted into a calender type schedule. I then
use a =countblank function to add up the blank spaces (which indicate
someone is working) and can then see how many people are working a
particular day.

The problem I am having is that some time an employee will have a
training day which instead of being a blank space will eb marked as
(TRN). This however causes errors with my =countblank function, and
the employees are then counted as being off when they are in fact
training.

Basically I want to use a =countblank function then put an exception
modifier at the end so that days marked "trn" or other designations are
counted by the function. I am not too familiar with doing these types
of functions. I've thought of using a =countA function to include in
the same path...any way just looking for the best way to do this.

Thanks in advance


--
JackBall
------------------------------------------------------------------------
JackBall's Profile: http://www.excelforum.com/member.php...o&userid=32781
View this thread: http://www.excelforum.com/showthread...hreadid=526076