COUNTIF statement with 3 criteria checks
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....
|