software

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 quot;oquot; 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 quot;trnquot; 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: www.excelforum.com/member.php...oamp;userid=32781
View this thread: www.excelforum.com/showthread...hreadid=526076Use the countif formula

=countif(range,quot;put less than and greater than signs herequot;amp;quot;oquot;)

This will tell you how many cells do not contain a quot;oquot;. ('lt;' 'gt;')

That is how I would do it based on your model.--
swatsp0p------------------------------------------------------------------------
swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
View this thread: www.excelforum.com/showthread...hreadid=526076
If I understand you correctly, you really are trying to include
everything except those with a 'o'. Couldn't you just use a countif to
find the number of 'o' and then subtract this from the total?--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: www.excelforum.com/member.php...oamp;userid=24380
View this thread: www.excelforum.com/showthread...hreadid=526076