concatenate and if statements

have if statement for a current project: =Ij($d$42="Raymond",countif($b$57:$n$57,WkrTable($d$20),0) wich can have far too many variants (up to 50).  Far too cumbersome, far too complex.  Have tri...