Lottery Filter#2, Low/High Digits, in Single CELL with "-"

I would think a simpler way of doing it would be via your own user function or by first splitting the cells into columns eg. column H to L would be the individual numbers (use MID). However if you really want to do it with a single formula try:

=SUM(IF(INT(MID(G6,1,2))<=18,1,0)+IF(INT(MID(G6,4,2))<=18,1,0)+IF(INT(MID(G6,7,2))<=18,1,0)+IF(INT(MID(G6,10,2))<=18,1,0)+IF(INT(MID(G6,13,2))<=18,1,0)) & "/" & SUM(IF(INT(MID(G6,1,2))>18,1,0)+IF(INT(MID(G6,4,2))>18,1,0)+IF(INT(MID(G6,7,2))>18,1,0)+IF(INT(MID(G6,10,2))>18,1,0)+IF(INT(MID(G6,13,2))>18,1,0))

basically just separates out each number using MID and will do a count if <=18 then if > 18

Apologies, did not refresh before answering the question, already answered above