Excel - COUNT Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a help in analysis of one seconds data for frequency reading on the national grid. I have to count number of events when frequency below certain point was recorded below certain frequency point for certain period of time
Solved by A. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 26/06/2018 - 10:41
Excelchat Expert 26/06/2018 - 10:41
Hello! How are you?
User 26/06/2018 - 10:41
I have a problem with some analysis.
User 26/06/2018 - 10:41
Good very well.
Excelchat Expert 26/06/2018 - 10:41
That's good to hear.
Excelchat Expert 26/06/2018 - 10:42
Let me confirm my understanding of your problem statement.
User 26/06/2018 - 10:42
I can see we have only 19 minutes so straight to the point.
Excelchat Expert 26/06/2018 - 10:43
You need to count the number of instances a frequency falls below a certain number for a certain period of time in your data right?
User 26/06/2018 - 10:43
yes but also for few different condition.
Excelchat Expert 26/06/2018 - 10:43
It's okay - if we need more time we are allowed for a maximum of 2 20-minutes extension per session for free.
Excelchat Expert 26/06/2018 - 10:43
Okay, could you share with me your file so I can have a better view of your data structure?
User 26/06/2018 - 10:44
If that last for between 0-2 seconds or 5-15 seconds
Excelchat Expert 26/06/2018 - 10:44
Then we can further expound on the other conditions.
Excelchat Expert 26/06/2018 - 10:45
Okay, I can see you paste the data in the document preview
Excelchat Expert 26/06/2018 - 10:45
How do i tell if they last for X no. of seconds?
User 26/06/2018 - 10:46
difference between recorded times
Excelchat Expert 26/06/2018 - 10:47
Where do I see the recorded times?
User 26/06/2018 - 10:47
column a
Excelchat Expert 26/06/2018 - 10:47
I can see there is a date and time stamp in column A but until the minute data only. Could you show me an example?
Excelchat Expert 26/06/2018 - 10:48
May I know what is the range of frequency you want to include in the count?
Excelchat Expert 26/06/2018 - 10:50
Hello? Are you still with me?
Excelchat Expert 26/06/2018 - 10:54
Hi, I am sorry I will not be able to include the second condition you made mention based on the duration if we can't clear up the question on how to compute for the duration...
Excelchat Expert 26/06/2018 - 10:55
What I have provided so far is the count on event based on the frequency below a specified number as indicated in cell G2 - which you could change base on what really is the requirement.
Excelchat Expert 26/06/2018 - 10:58
HI, this session will automatically end in less than 3 minutes.
Excelchat Expert 26/06/2018 - 10:58
I hope you are able to come back and confirm solution provided so far.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc