Counting the number of celling in a certain timeframe

Question

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?

oliverscheurich · Answer

RosanaLC&nbsp;=SUMPRODUCT((September!D2:D1500&gt;D1)*( September!D2:D1500&lt; E1))Maybe with this formula. You can dynamically enter the time in cells D1 and E1.&nbsp;

rosanalc · Answer

OliverScheurich&nbsp;I have the values in DIts only one colloum

rosanalc · Answer

tried it applying it to my sheet with the cells i have and still get errorNot sure where im going wrong

Forum Discussion

Counting the number of celling in a certain timeframe

3 Replies

Resources