LinkBack URL
About LinkBacks
Try in O4;
Column M & N may not be used with this formula, it can be deleted if needed.
=IF($L$4:$L$9="RCAL",SUMPRODUCT(($A$4:$A$7+$B$4:$B$7>=$I4+$J4)*($A$4:$A$7+$B$4:$B$7<=($I4+$K4+IF($K4-$J4>0,0,1)))*($D$4:$D$7=O$3)*($E$4:$E$7=$Q4)),"")
Try in O4;
Column M & N may not be used with this formula, it can be deleted if needed.=IF($L$4:$L$9="RCAL",SUMPRODUCT(($A$4:$A$7+$B$4:$B$7>=$I4+$J4)*($A$4:$A$7+$B$4:$B$7<=($I4+$K4+IF($K4-$J4>0,0,1)))*($D$4:$D$7=O$3)*($E$4:$E$7=$Q4)),"")
Quang PT
i didn't quite get this one to work but I think that could be me more than anything. Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks