Sumproduct help

J

JR

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: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."))),"-",
(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."))))
 
B

Bernard Liengme

Use form =SUMPRODUCT(--(F1:A1000>=TIME(0,3,0)))

General note: it would be much simpler if Sheet names could be omitted or
reduced to Sheet1 in examples- easier to read.
 
Top