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;))))

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()