Totals from a field that includes a range

I have a field that includes a number range for each record: “5-10”, “15-20”, etc. On another table, I would like to do a rollup that adds together all the first and last numbers in those ranges, displaying “20-30” essentially. Is there a rollup formula that can find the first and last numbers in a range?

The only thing I’ve thought of so far is separating that range into 2 fields and then combining them into the other table with a concatenate, but I’m hoping there’s a solution that keeps the range in a single field

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.