Two formulae in same cell

[The Grim Discovery]

Hello Legends

I've got a column of data containing the follow formula

COUNTIFS('Primary'!$A$2:$A$5000,B$1,'Primary'!$D$2:$D$5000,$A2)&"/"&COUNTIFS('Secondary'!$A$2:$A$5000,B$1,'Secondary'!$D$2:$D$5000,$A2)

This works well in each cell as it gives me what I'm looking for a number for: 'primary' / a number for 'secondary' - but i need to produce a total for this column which sums up all the 'primary' formulae separately from 'secondary' formulae. Is there anyway of doing this that doesn't include helper columns.

Thanks

Primary/Secondary
2/3
7/9
1/8
Total:
10/20	<<Trying to achieve this

 

[etaf]

try
=SUM(TEXTBEFORE(A2:A4,"/")*1)
and
=SUM(TEXTafter(A2:A4,"/")*1)

so =SUM(TEXTBEFORE(A2:A4,"/")*1)&"/"&SUM(TEXTAFTER(A2:A4,"/")*1)

Book3
	A
1	Primary/Secondary
2	2/3
3	7/9
4	1/8
5	Total:
6	10/20
Sheet1

Cell Formulas
Range	Formula
A6	A6	=SUM(TEXTBEFORE(A2:A4,"/")*1)&"/"&SUM(TEXTAFTER(A2:A4,"/")*1)

 

[The Grim Discovery]

try
=SUM(TEXTBEFORE(A2:A4,"/")*1)
and
=SUM(TEXTafter(A2:A4,"/")*1)

so =SUM(TEXTBEFORE(A2:A4,"/")*1)&"/"&SUM(TEXTAFTER(A2:A4,"/")*1)

Book3
	A
1	Primary/Secondary
2	2/3
3	7/9
4	1/8
5	Total:
6	10/20
Sheet1

Cell Formulas
Range	Formula
A6	A6	=SUM(TEXTBEFORE(A2:A4,"/")*1)&"/"&SUM(TEXTAFTER(A2:A4,"/")*1)

That's brilliant. Thank you. Never come across the TEXTBEFORE and AFTER. Thanks again.

 

[etaf]

you are welcome
a lot of text functions added to 365v version now

 

[The Grim Discovery]

Honestly, you've made a tricky day for me into a much better one...appreciated