COUNTIF() not working as expected?

The expected results for the count to next set is for excel to count how many are needed for next set..
Formula test.xlsx

some how I need it to count to the next set with it understanding that tiers 1 through 4 are 1111, 2222,3333 etc... tiers 4 and 5 are 1and1,or 2and0,or 0and2, for first set, then 2and2, or 1and3, 3and1, or 4and0, or 0and4. I need it to understand all the possible combos needed for the next and then calculate how many are missing to get to the next set.. Again thanks for the help...