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