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

excel sum if contains partial text from another cell