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.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
dreicer_Jarr 
Register To Reply
Bookmarks