Don't use a whole column unless you use XL-2007

=SUMPRODUCT(--(Sheet4!C1:C1000=TIME(8,0,0)),--(Sheet4!C1:C1000<=TIME(16,0,0))


"Nycole" wrote:

I am using the following and I am getting #NAME?

=SUMPRODUCT(--(time_range=Sheet4!C:C(8,0,0)),--(time_range<=Sheet4!C:C(16,0,0)))

"Bob Phillips" wrote:

=SUMPRODUCT(--(time_range=TIME(8,0,0)),--(time_range<=TIME(16,0,0))

the time_range must be an explicit range it cannot be whole columns.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Nycole" wrote in message
...
I have a list of times 0:00 - 24:00 and days and I need to find out how
many
files were processed between in an 8 hour shift per day

Entry Number TIME Est. Date of Arrival
9065233-5 14:56 1/1/2008
9065234-3 15:11 1/1/2008
9065235-0 15:26 1/1/2008
9065240-0 16:02 1/1/2008
7082203-1 18:30 1/1/2008
9065245-9 1:01 1/2/2008
3705209-4 1:41 1/2/2008
3705220-1 3:05 1/2/2008