| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
countif but have two criteria
I have a cell range that has 3 different types of cells in it. It's about
training, some have date or period when training was completed, some have "due" plus date or period, and some are blank, yet to be filled. I need to add the blank cells to the due ones, tried countif but only one criteria allowed, tried sumproduct (--(A1:A500="*due*"),--(A1:A500="")) didn't work (value error in part two). How do I add the blanks and the dues together. Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF statement with 3 criteria checks | Excel Discussion (Misc queries) | |||
| COUNTIF with two criteria | Excel Worksheet Functions | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Threaded Mode
