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

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

Direct link: https://paste.plurk.com/show/0i8cy8O8SVvThTagXN2K

Plurk paste