| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a criteria to sumproduct
Hello,
Question is what would the formula look like if I had to add the criteria ACD Incoming to the following formula? =SUMPRODUCT(--(Associate_Event_Dump!$E1:$E17000=TIME(0,0,0)),--(Associate_Event_Dump!$E1:$E17000<=TIME(0,29,59)),--(Associate_Event_Dump!$N1:$N17000="Q10550")) So the final formula would count the number of times Q10550 appears in the time frame referenced if column C1:C17000 has ACD Incoming? Thanks for the help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add a criteria to sumproduct
=SUMPRODUCT(--(Associate_Event_Dump!$E1:$E17000=TIME(0,0,0)),--(Associate_Event_Dump!$E1:$E17000<=TIME(0,29,59)),--(Associate_Event_Dump!$N1:$N17000="Q10550"),--(Associate_Event_Dump!$C1:$C17000="ACD Incoming"))
Each additional criteria requires an argument to the sumproduct function of the form "--(Range=value)" "JR" wrote: Hello, Question is what would the formula look like if I had to add the criteria ACD Incoming to the following formula? =SUMPRODUCT(--(Associate_Event_Dump!$E1:$E17000=TIME(0,0,0)),--(Associate_Event_Dump!$E1:$E17000<=TIME(0,29,59)),--(Associate_Event_Dump!$N1:$N17000="Q10550")) So the final formula would count the number of times Q10550 appears in the time frame referenced if column C1:C17000 has ACD Incoming? Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumProduct with criteria list | Excel Worksheet Functions | |||
| Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
| Using Sumproduct with multiple Criteria | Excel Worksheet Functions | |||
| Sumproduct w/date criteria not working | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
