Summing a column with numbers containing /

[Captain Lake]

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.

 

[Dave Patton]

TextSplit.xlsm
	G	H
1
2
3	5/1	40/8
4	10/2	40/8
5	25/5
6
fc

Cell Formulas
Range	Formula
H3	H3	=SUM(--LEFT(G3:G5,FIND("/",G3:G5)-1))&"/"&SUM(--RIGHT(G3:G5,1))
H4	H4	=SUM(--TEXTBEFORE(G3:G5,"/"))&"/"&SUM(--TEXTAFTER(G3:G5,"/"))

 

[Captain Lake]

Thanks for the help Jeff and Scott, much appreciated!

 

[Captain Lake]

Thanks for the help Jeff and Scott, much appreciated!

Hello again. I just realized the formula I'm using doesn't account for filtering, that is, when I filter the data my formula doesn't update.

The formula I'm using is SUM(--TEXTBEFORE(N2:N6892,"/",,,,0))&" / "&ROUNDUP(SUM(--TEXTAFTER(N2:N6892,"/",,,,0)),0).

I've tried replaced the SUMs with SUBTOTAL

Can you help?

 

[Jeffrey Mahoney]

Please try this. Create another helper column that detects if each row is visible or not. Use the formulas below

Book11
	G	H	I	J
2	Date	Visible		40/8
3	5/1	1
4	10/2	1
5	25/5	1
Sheet1

Cell Formulas
Range	Formula
J2	J2	=LET(FltrRng,FILTER(G3:G5,H3:H5=1),SUM(--TEXTBEFORE(FltrRng,"/"))&"/"&SUM(--TEXTAFTER(FltrRng,"/")))
H3:H5	H3	=SUBTOTAL(103,G3)

 

[Captain Lake]

Thanks Jeff, that works great!