Hi all! I am having a hard time figuring this out. I work in ticketing and have a sheet that is showing me all the seating in a venue by section. In one cell it has a range of numbers representing how many seats are on a specific row (ex. 1-10). I would like to create a column next to it showing the total number of seats on that row, so I can then easily add them together for a total. Some rows do now begin with seat 1. Any ideas?