|
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. |
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. |
| All times are GMT +1. The time now is 01:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com