Hello,

I have a relatively simple score-keeping spreadsheet I am working on.
The normal format for the scores to be entered is like '48-1' or
'47-3', etc. Some of the aggregates are the sum of various stages or
matches, which for various reasons are not necessarily in contiguous
blocks or sections on the sheet. As an example, I need to tally up
the values from B3 (48-1), F3 (47-3), and I3 (48-5)... i.e. 48+47+48
'-' 1+3+5.

What I have working thus far is this:

=LEFT(B3,2)+LEFT(F3,2)+LEFT(I3,2)&"-"&RIGHT(B3)+RIGHT(F3)+RIGHT(I3)&"V"
which gives me a total of 143-9V

For one line of three values, its not too bad. For 8-10 lines of
between 5 and 10 values... it starts making me worry about errors
creeping in and causing me grief. Plus I'd like a way to make this
more 'portable' for future use in other sheets.

Is there a way to get SUM() to accept the return value from LEFT() and/
or RIGHT() as input data? I tried it a couple different ways and
couldn't make it work.

Any help would be much appreciated!

TIA,

Monte