How do you count occurances of something over a period of time?

Claudius02

New Member
Joined
Oct 16, 2019
Messages
1
I have a spread sheet with the following columns:


User name
Date
Time
Time of Day
Error Code
Status
John Doe11/1/201612:25:01AM123Success
John Doe11/1/20168:25:00PM123Success
Jane Doe11/1/20178:25:00AM234Failure

<tbody>
</tbody>

So I want to count how many times during a specific time period John Doe, Jane Doe, or another person used something. So, for example how many times a person used something for a 24 hour period, or used it during a month, day, year, etc.

Another issue would be how many times the status over a specific time period was a success, or failure.

EDIT:
the specific time periods would be 24 hours, week, month, year
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,974
Office Version
365
Platform
Windows
Welcome to the Board!

Take a look at using the COUNTIFS formula, which allows you to count records meeting certain criteria.
See here for an example on how to do a date/time range: https://exceljet.net/formula/count-cells-between-dates
To add the person, just add another set of criteria (which name range and name value).
 

Watch MrExcel Video

Forum statistics

Threads
1,095,382
Messages
5,444,134
Members
405,269
Latest member
Kjtakke

This Week's Hot Topics

Top