Using Countif with another functions

I am trying to write a report using the COUNTIF function but in order to accomplish what the function needs to do, I need to use it with another function. Here is what I am trying to do:

I have a worksheet that is my data table and a worksheet that is my report.
I have a attached a visual to make this more clear. I am trying to count in the report the number of occurrences in the data table for 1A, 1B, etc for all rows that have Region # 0691 as 0691 is the region # for Chicago. There is more than 1 "region" that I need to do this for. I tried to use an IF statement and then embed a COUNTIF statement into that but it did not work as it returned a count of all cells that had 1A, not just the ones with Region # 0691. If anyone has any suggestions please let me know. I am trying to do this without using hidden cells or adding more worksheets. Thanks in advance for the help.