close
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=quot;0 hr. 00
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))),quot;-quot;,
(SUMPRODUCT((daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 00
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))))
全站熱搜