Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct with Date Range and One Condition that is Text
Hello to all of you Excel Experts,
HELP, pretty please. I have 2 formulas I am trying to combine. I had to break them out, to try and troubleshoot my initial error, #Name? Both of these formulas worked, but I need them combined. I am pulling from a different worksheet and working in Excel 2003. I am trying to identify in one column (Column A) the site visits along with another column (Column E) looking for a date range of 09/01/08 - 09/30/08. The issue is I have to do a search because for some reason the names in Column A (Site Visits) were not picking up when I had the formula combined. =SUMPRODUCT(--(ISNUMBER(SEARCH('Project KPI Detail'!A15:A35,"Construction Start")))) =SUMPRODUCT(--(YEAR('Project KPI Detail'!$E$16:$E$37)=2008),--(MONTH('Project KPI Detail'!$E$16:$E$37)=9)) Thank you, The Novice |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to total text in range, if true to condition | Excel Worksheet Functions | |||
Sumif function with a date range condition statement | Excel Discussion (Misc queries) | |||
condition sumif commands based on date range? | Excel Discussion (Misc queries) | |||
Search for Condition, Text based, Date Range, Occurrences | Excel Worksheet Functions | |||
sumproduct-condition as a range | Excel Discussion (Misc queries) |