Excel sum if contains partial text from another

Excel sum if contains partial text from another pictures 5
Home > Excel sum if contains partial text from

Excel sum if contains partial text from another