Splitting the cells is not a lot of work, just create two columns and in the first column type
Formula: copy to clipboard
=LEFT(C3,4)
and in the second type
Formula: copy to clipboard
=Right(C3,4)
Drag both down and then plug in your CountIF.