N
Nycole
I have this and it works great!! BUT I need to add a countif into this. How
do I do that? I need to break this down to how many per shift per team.
=SUMPRODUCT(--(Sheet4!B1:B20000=A4),--(Sheet4!D120000>=TIME(0,0,0)),--(Sheet4!D120000<=TIME(7,59,59)))
Entry Number Est. Date of Arrival Created On Port of Entry Team
4093775-2 1/2/2008 12/10/2007 0:00 12:45:49 PM 0708-010 C
8707657-1 1/1/2008 1/1/2008 0:00 2:38:13 PM 0708-010 T
8781871-7 1/1/2008 1/1/2008 0:00 5:07:51 PM 0708-010 X
8781872-5 1/1/2008 1/1/2008 0:00 5:16:28 PM 0708-010 X
8781873-3 1/1/2008 1/1/2008 0:00 6:20:48 PM 0708-010 X
8781874-1 1/1/2008 1/1/2008 0:00 6:25:11 PM 0708-010 X
do I do that? I need to break this down to how many per shift per team.
=SUMPRODUCT(--(Sheet4!B1:B20000=A4),--(Sheet4!D120000>=TIME(0,0,0)),--(Sheet4!D120000<=TIME(7,59,59)))
Entry Number Est. Date of Arrival Created On Port of Entry Team
4093775-2 1/2/2008 12/10/2007 0:00 12:45:49 PM 0708-010 C
8707657-1 1/1/2008 1/1/2008 0:00 2:38:13 PM 0708-010 T
8781871-7 1/1/2008 1/1/2008 0:00 5:07:51 PM 0708-010 X
8781872-5 1/1/2008 1/1/2008 0:00 5:16:28 PM 0708-010 X
8781873-3 1/1/2008 1/1/2008 0:00 6:20:48 PM 0708-010 X
8781874-1 1/1/2008 1/1/2008 0:00 6:25:11 PM 0708-010 X