I have the following data in Column A:

9.5/4/6

3/4/6.5/7.8

My list goes on for over 700 entries.

The number of values separated by a slash changes as does the number of decimal points in each value.

I need to get the sum of each row to show up in Column B.

I prefer a non VBA solution if possible.