NETWORKDAYS does not work with arrays. Try using a helper column. For
example, enter the following formula in a column, let's say Column F...

F5, copied down:

=NETWORKDAYS(C5,TODAY())

Then, try the following formula...

=SUMPRODUCT(--(D5:D10000="BOB"),--(E5:E10000="To be Sent to Carrier
(TCAR)"),--(F5:F100001),--(F5:F10000<5))

Hope this helps!

In article ,
Malvaro wrote:

I was digging around and found a winner using the SUMPRODUCT, so
now I got the Column B & C working correctly:

=SUMPRODUCT((D5:D10000="BOB")*(E5:E10000="To be Sent to Carrier
(TCAR)"))

I now need to correct the final criteria which sets the date range, so
this
can be inserted into the above working formula:

the end of working formula...
"*(NETWORKDAYS(C5:C10000,TODAY())1)*(NETWORKDAYS( C5:C10000,TODAY())<5))"

I'm currently getting the #VALUE error....