LinkBack URL
About LinkBacks
Hi
use in N3 the following formula
Formula:
=IF(K3="OK",NETWORKDAYS(AGGREGATE(14,6,($F$3:$F$27)*($A$3:$A$27=A3)*($C$3:$C$27=C3)*($J$3:$J$27=1),1),H3),"")
and copy down
Hi
use in N3 the following formula
Formula:=IF(K3="OK",NETWORKDAYS(AGGREGATE(14,6,($F$3:$F$27)*($A$3:$A$27=A3)*($C$3:$C$27=C3)*($J$3:$J$27=1),1),H3),"")
and copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks