Hi RobExcel,


Welcome to ExcelFox!!

You can easily done this by creating a Pivot Table.

Create a pivot table > Put Order Country in Page Field, Country in both Row field as well as Data field.

Now select the order country , you will get the list of countries and their count.