Good Afternoon

I have 2 columns one with a string of numbers and the other a number

1,-,-,-,-,-,-,-,-,- 247
-,2,-,-,-,-,-,-,-,- 34
-,-,3,-,-,-,-,-,-,- 34
-,-,-,4,-,-,-,-,-,- 24
-,-,-,-,5,-,-,-,-,- 2608
-,-,-,-,-,6,-,-,-,- 2


What I want to do is search the range of text string to find lets say the number 2 (the numbers appear in the same position every time or is replaces with the - ) then sum the next column that relates to the number 2 etc

I have 1023 lines of text string (total number of combinations of 10)



Thank you