bgeier Wrote:
Did you enter the formula as an array formula <ctrl<shift<enter
instead of just <enter?

You could also try sumproduct, or countif nested with if statements

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....


--
Malvaro
------------------------------------------------------------------------
Malvaro's Profile: http://www.excelforum.com/member.php...o&userid=29589
View this thread: http://www.excelforum.com/showthread...hreadid=547943