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

Use the countif formula

=countif(range,"put less than and greater than signs here"&"o")

This will tell you how many cells do not contain a "o". ('<' '')

That is how I would do it based on your model.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=526076