I was getting ready to change the yes/no in my spreadsheet to 1 or 0 for ITM. Then your countif function should work, and you can also build pivot tables that show the sum of ITM for each category (SNG or MTT)