The only things I changed were the cell references ie my data ranges to be
analyzed are in F and G and the criteria (ranges) are in J and K...

"Bob Phillips" wrote:

Tell me how and why you are modifying it.

--
__________________________________
HTH

Bob

"Cita" wrote in message
...
Thanks...but I can't get it to work. Maybe it's because I haven't used
these
functions before. I keep getting the "#VALUE!" error when I try to modify
it.

Thanks again...

"Bob Phillips" wrote:

=SUMPRODUCT(--(Sheet1!$A$2:$A$20=B$1),--(Sheet1!$B$2:$B$20=--(LEFT($A2,2)&":"&MID($A2,3,2))),--(Sheet1!$B$2:$B$20<=--(MID($A2,6,2)&":"&RIGHT($A2,2))))

--
__________________________________
HTH

Bob

"Cita" wrote in message
...
Hello again-
I have the following categories:
(TIME) 12/31/2007 1/1/2008 1/2/2008
A 0800 1959
B 2000 0759
C 0000 1159
D 1200 2359
E 0700 1900
F 1900 0700

I also have 2 columns, 1 has a date and 1 the time. I want to count how
many
records meet the (1) date criteria and (2) fall within the time
range...is
this possible? I've used SUMPRODUCT before but never with a
conditional
like
this.

Thanks!