Captain Lake
New Member
- Joined
- Jan 11, 2024
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I've a spreadsheet with data in 1 column listing internet download/upload speeds. So for example,
5/1
10/2
25/5
I'd like to sum the numbers in front of the /, and the numbers after the /, and keeping the same form, put the sum in one cell. In this example, it would sum to 40/8.
Is this possible?
Thanks for the help.
5/1
10/2
25/5
I'd like to sum the numbers in front of the /, and the numbers after the /, and keeping the same form, put the sum in one cell. In this example, it would sum to 40/8.
Is this possible?
Thanks for the help.