How would I count the number of times a range was above/below a certain number within certain time ranges?
So I have my time ranges and "data" and I want to know how many times for each hour (12, 1 pm, 2 pm etc.) the "data" or time in minutes was say greater than 30? See attachment for clarity...
Last edited by dreicer_Jarr; 10-14-2008 at 07:09 PM.
I can't tell what you're trying to do from your example. Your workbook has links to a different workbook.
Entia non sunt multiplicanda sine necessitate
I want to know how many instances are over or under a specified criteria (e.g. >=30) by hour of the day. So if I had 30 instances between 2 and 3, I would want to know how many were over or equal to 30.
The formula needs to look at three collumns. The first two are dates/times and will tell it whether the time is between what hours. The second is the "instances" or data that is being compared to the criteria. See this spreadsheet....the stuff under row 13 is just my setup...
In B14 and copy down and across,
=SUMPRODUCT( ($B$2:$B$7 >= $A14 + B$13) * ($B$2:$B$7 < $A14 + B$13 + "1:00") * ($C$2:$C$7 >= 30) )
The times in S13:Y13 need to be changed to not be on 1/1/1900, unless they are intended to be on the following day.
Last edited by shg; 10-14-2008 at 10:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks