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

[Claudius02]

I have a spread sheet with the following columns:


[TABLE="width: 500"]
<tbody>[TR]
[TD]User name
[/TD]
[TD]Date
[/TD]
[TD]Time
[/TD]
[TD]Time of Day
[/TD]
[TD]Error Code
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]11/1/2016[/TD]
[TD]12:25:01[/TD]
[TD]AM[/TD]
[TD]123[/TD]
[TD]Success[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]11/1/2016[/TD]
[TD]8:25:00[/TD]
[TD]PM[/TD]
[TD]123[/TD]
[TD]Success[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]11/1/2017[/TD]
[TD]8:25:00[/TD]
[TD]AM[/TD]
[TD]234[/TD]
[TD]Failure[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Joe4]

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