COUNTIF() not working as expected?

Hard to think about 3am

thank you for the help, still not working right though. Sorry I'm really trying to get "it" but having a hard time, please read the included notes in the excel file that will help explain what each set is (I have this formula correct on another sheet).. Anyway it is just the count I can't get right...Formula test.xlsx