Count Unique Values with multiple criteria

Good morning,

For this exercise I need to get a total of all AZ, Off, Orders with a value of "1" but only counting each repeating ID number once (for orders of 1). This is a shortened version with the full spreadsheet containing On and Off Premise, 8 different states and multiple order counts. I've attached an example with a grid to the right which will be my final outcome but need the first formula that I can then alter as needed. The Unique part is what is stopping me. I can count the Orders with 1, but it is counting all of them and not the unique ones.

Orders ID Premise State
1 9170751 OFF AZ
1 9170751 OFF AZ
1 9170752 OFF AZ
1 9170757 OFF AZ
1 9170757 OFF AZ
0 9170752 OFF AZCount Unique Values.xlsx
10 9170751 OFF AZ
12 9170752 OFF AZ
11 9170757 OFF AZ
0 9170757 OFF AZ
2 9170751 OFF AZ
8 9170757 OFF AZ
2 9184526 OFF AZ

Added on sheet1 the formula though it might slow down the spreadsheet. In sheet2as an alternative,, I added a pivot table (and selected the "Add this data to the Data Model" check box) so that I can count distinct values.
Alex