Thread: Add a criteria to sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default 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.

Reply With QuoteReply With Quote