| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard characters in countif array formulas | Excel Discussion (Misc queries) | |||
| max limit to characters in COUNTIF function? | Excel Discussion (Misc queries) | |||
| Need help on countif and sumif function with dates and wildcard characters | Excel Discussion (Misc queries) | |||
| Countif using Wild Card Characters | Excel Worksheet Functions | |||
| Count Characters | Excel Worksheet Functions | |||
Threaded Mode
