count cells if ADJACENT row values meet criteria

if your DateTime data are in cells A2:A24, and Value data are in B2:B24, use (in any other cell) the following ARRAY formula (see signature) to get the count like you desire:

=SUM(--(FREQUENCY(IF($B$2:$B$24>1000,ROW($B$2:$B$24)-MIN(ROW($B$2:$B$24))+1),IF($B$2:$B$24<=1000,ROW($B$2:$B$24)-MIN(ROW($B$2:$B$24))+1))=4))

or regular formula:

=SUM(--(FREQUENCY(($B$2:$B$24>1000)*(ROW($B$2:$B$24)-MIN(ROW($B$2:$B$24))+1),($B$2:$B$24<=1000)*(ROW($B$2:$B$24)-MIN(ROW($B$2:$B$24))+1))=4))