| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF with unconditional AND on cell dates
hi,
ActiveCell.Formula = "=SUMPRODUCT(--(Requests!H1:H65535<=DATE(2012,4,31))*(Requests!D1 :D65535=""Marcus Comins""))" or Dim dt As Long, rng1 As Range, rng2 As Range dt = DateSerial(2012, 4, 30) Set rng1 = Range("H1:H65535") Set rng2 = Range("D1:D65535") ActiveCell = Evaluate("SUMPRODUCT((Requests!" & rng1.Address & "<=" & dt & ")*(Requests!" & rng2.Address & "=""Marcus Comins""))") -- isabelle Le 2012-04-16 05:18, Aramazd a écrit : Works, Thanks a lot!! The challenge now would be actually implementing this code in VBA :D |
| 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
