Apr 11 2022 10:51 AM
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", September!D2:D1500,"< 12:00:00")
but i get an error:
Formula parse error
can someone help me?
Apr 11 2022 11:15 AM
=SUMPRODUCT((September!D2:D1500>D1)*( September!D2:D1500< E1))
Maybe with this formula. You can dynamically enter the time in cells D1 and E1.
Apr 11 2022 11:17 AM
Apr 11 2022 11:20 AM