=AND(SUMIF($F$9:$F, $F9, $G$9:$G) <> 0,REGEXMATCH($F9, "RES")) (Plurk Paste)

1	=AND(SUMIF($F$9:$F, $F9, $G$9:$G) <> 0,REGEXMATCH($F9, "RES"))

Direct link: https://paste.plurk.com/show/plNZ69U1NHH8xvolHyoi

Plurk paste