countif times

  1. D

    Countif by Date and within different overnnight Time segments

    We are trying to count the number of leads (segmented by Lead Score) that came in through our internet forms overnight that the call center will have to respond to on the next morning when the call-center opens. Our call center is open Monday-Thursday (7am-7pm) & Friday (7am-5pm); it is closed...
    • DigitalRhoads
    • Thread
    • countif 2 conditions met countif 3 conditions met countif dates range countif times lead scores
    • Replies: 2
    • Forum: Excel Questions
  2. F

    COUNTIF - tracing results for further action

    I am working from the difference between two times. If the difference is >15 or >20 - different events occur. I can use =COUNTIF(W:W,">0.0138888888888889") to count orders later than 20 minutes for example. In this instance - there were 9. But, I'd like to also return the value of column D -...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top