| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating a countif with sumproduct + Date
Hello,
Is it possible to improve this piece of code? Currently I cannot run it, it tells me I need a ")" on the date paremeter. Can somebody tell me what am I doing wrong? Thanks in advance. iIncidentsMC = iIncidentsMC + Application.WorksheetFunction.SumProduct(--(Sheets("Incidents").Range("F1:F65535"<=DATE(2012, 4, 31))*(--Sheets("Incidents").Range("F1:F65535"=Date(2012,4 ,1)*(Sheets("Incidents").Range("C1:C65535" = "Marcus Cominus")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct or Countif - Counting Occurances within a Date Range | Excel Worksheet Functions | |||
| Countif or sumproduct using a date range and another criteria | Excel Discussion (Misc queries) | |||
| Calculating rates using sumproduct | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| SumProduct/CountIf dilemna + Date Range | Excel Worksheet Functions | |||
Linear Mode
