Forum Discussion
Counting the number of celling in a certain timeframe
I have a sheet where I input the times an alarm for example, happens. I want to count the number of celling during 6am to 12am for example. I have tried : =COUNTIFS(September!D2:D1500,"> 06:00:00...
=SUMPRODUCT((September!D2:D1500>D1)*( September!D2:D1500< E1))Maybe with this formula. You can dynamically enter the time in cells D1 and E1.
- tried it applying it to my sheet with the cells i have and still get error
Not sure where im going wrong
