Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default sumproduct

I am using the following to count the number of times a time period occurs.
I would like to ask someone to show me how I can write this to count the
number of time occurances that happen which are 3 min and higher.

Thanks

=IF(ISERROR(SUMPRODUCT((daily_CS_Ticket_Per!F1:F10 00="0 hr. 00
min.")+(daily_CS_Ticket_Per!F1:F1000="0 hr. 01
min.")+(daily_CS_Ticket_Per!F1:F1000="0 hr. 02 min."))),"-",
(SUMPRODUCT((daily_CS_Ticket_Per!F1:F1000="0 hr. 00
min.")+(daily_CS_Ticket_Per!F1:F1000="0 hr. 01
min.")+(daily_CS_Ticket_Per!F1:F1000="0 hr. 02 min."))))