Counting in different hours

Filip01

New Member
Joined
Oct 17, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
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.
Untitled.png
Please pay attention to columns E (Time) and column N (totals of emails sent, opened and clicked).
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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

New Member
Joined
Oct 17, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Attachments

  • Untitled1.png
    Untitled1.png
    233.9 KB · Views: 3

Watch MrExcel Video

Forum statistics

Threads
1,119,255
Messages
5,576,981
Members
412,756
Latest member
ni6hant
Top