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).