Here are two formula options to sum a range of cells, when each cell holds a delimiter (in this example, a hyphen character), and you want to separately sum the cells’ numbers to the left and right sides of the delimiter.

In the picture, the array formula in cell B14 that sums the San Francisco Giants’

…