View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rafa Rafa is offline
external usenet poster
 
Posts: 1
Default How to tell COUNTIF to not count a few characters

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!