I want to calculate a Sum/Total of all those cells that also contain some text strings For example:

Cell A1 has

"ABC-2"

Cell B1 has

"DEF-3"

Cell C1 has

"XYZ-5"

So the total would be 10

But as this an example, it is pretty easy to calculate this manually but i have a long list of alphanumeric values. The good part is, these numbers are separated by a hyphen (-).

I need a excel formula/function to do this calculation. Please help me out.