FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
How can I sum these values that are separated by a hyphen other than using =LEFT(A2,FIND("-",A2)-1)+MID(A2,FIND("-",A2)+1,2)
There will always only be one hyphen and the two values will never be over two digits on each side of the hyphen.
Data Range
<tbody>
</tbody>
There will always only be one hyphen and the two values will never be over two digits on each side of the hyphen.
Data Range
A | B | |
1 | Count | Total |
2 | 1-2 | 3 |
3 | 10-3 | 13 |
4 | 11-12 | 23 |
<tbody>
</tbody>
Last edited: