Counting in different hours

[Filip01]

Hi! I need to calculate the total of emails sent opened and clicked. I need to have the data in different hours, for example 01:00-02:00 (hourly performance). I have tried multiple formulas but it does not work. I have tried COUNTIF, but I always get the result 0, which is not correct.

Please pay attention to columns E (Time) and column N (totals of emails sent, opened and clicked).

 

[mole999]

can you do this in xl2bb so its placeable in another spreadsheet for testing, also what is the formula have worked with

I wouldn't be happy having my email exposed

 

[Filip01]

I have tried with =COUNTIF(N:N;"E:E>=09:00<10:00"). I do not know how to place the file in xl2bb :/. The email is not mine, i got it as a job application test, I guess they are working with google data. I do not know how to delete it so here it is again without the email data.