Hi Rafa
Countif is a very efficient function
=COUNTIF(F14:F43,"OFF*")
will deal with both Off and Off Site
=COUNTIF(F14:F43,"Admin")
Deduct these values from your other value to get the net figure.
--
Regards
Roger Govier
"Rafa" wrote in message
...
Im working on a colum that is a medical schedule for Doctor who will be
working that day so that I know how many exam rooms will be needed - right
now Im working with: =COUNTIF(F14:F43,"*") which tells me how many cells
are
not blank. But I would like to have countif not count cells in that same
colum who have values like: OFF, ADMIN, OFF SITE and etc. Am I using the
correct function? PLEASE HELP!
__________ Information from ESET Smart Security, version of virus
signature database 5172 (20100604) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 5172 (20100604) __________
The message was checked by ESET Smart Security.
http://www.eset.com