Google Spreadsheets: data selection by range, how to do?

Question

Google Sheets

I have a table of the following form:
ABCDE
01/25/2020 0:00:02 200 1 Ok

A- date, B- time. I need to take a certain date (for example, January 25, 2020) and if D ≥ 100, and the text in E = Ok, take the time in the range from 00:00 to 01:00 and count similar lines.

How to do?

Answer 1

Without a specific example, you'd better turn to help information and search the net.
There are three main ways to solve this problem:

1. Formulas. Count rows via COUNT using FILTER
   
2. Formulas. Implement a grouping query countin a QUERY formula
   
3. Scripts. Very large selection of variations