Hi guys,

I've been browsing through these forums for hours, but I can't find the
answer to a problem I am having with a formula...

I have a table which looks like this:

1 Date Time Day
2 1/1/2006 21:21 Sun
3 1/1/2006 22:27 Sun
4 1/1/2006 20:13 Mon
5 1/1/2006 22:13 Mon

I am attempting to create a formula where items which were received
within a specific timeframe -AND- on a specific day will be counted.
For instance: what are the amount of items which occurred on a -Monday-
_between_ -1:00 PM -and -2:00 PM-.

The following formula is the closest I could get, but unfortunately
does not produce the desired results (please note the items in red
indicate named ranges):

=SUMPRODUCT(TEXT(CallTime,"hh:mm")"02:00")*(TEXT( CallTime,"hh:mm")<"03:00"))/(COUNTIF(Day,"Mon"))

Your help would be IMMENSELY appreciated! :)


--
robotfighter
------------------------------------------------------------------------
robotfighter's Profile: http://www.excelforum.com/member.php...o&userid=33549
View this thread: http://www.excelforum.com/showthread...hreadid=533327