Add a criteria to sumproduct

J

JR

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

bpeltzer

=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)"
 
Top