Here's another one...
Data Range
G H I J 5 ----- ----- ----- 6 22-33-34-35-36 160 7 0/5 7 08-28-29-30-35 130 4 1/4 8 01-18-23-33-35 110 2 2/3
Entered in J6 and copied down:
=SUM(--(--MID(G6,{1,4,7,10,13},2)<=18))&"/"&SUM(--(--MID(G6,{1,4,7,10,13},2)>=19))
Bookmarks