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.
|