| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COUNT IF with unconditional AND on cell dates
I have a slight problem here any input would be appreciated.
Trying to gather a data that has 2 conditions where both of them have to be true. 1st condition Name 2nd conditionam Date Here is the code of what I haves so far. =COUNT(IF(Requests!H:H,"<="&DATE(2012,4,31),IF(Req uests!D:D,"Marcus Comins"))) Ironically enough trying to set this up in VBA however need to get the formula to fucntion in the first place. Thanks in advance Aram |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do count a cell range that include all dates prior to today? | Excel Discussion (Misc queries) | |||
| Count Dates between Dates exclude Text | Excel Discussion (Misc queries) | |||
| Making a Conditional Formula UNConditional | Excel Discussion (Misc queries) | |||
| Unconditional formatting | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
