Countif and Data Sorting

[Joneye]

Table 2 is the formula used in the outputs to table 2 (for explanation purpose). What im having an issue is going to Data Tab >> Sort >> Sort by Count >> Sort on Cell Values >> Order Largest to Smallest.

What is returned is not the order of higest number by country it fires out some random list (i think i may have an incorrect process or formula), any advice is apprecaited.

Table 1

Country​	Count​
Algeria​	5
Andorra​	1
Argentina​	35
Australia​	167

Table 2

Country​	Count​
Algeria​	=COUNTIF(Sheet1!$B$2:$B$10000,Dashboard!G2)​
Andorra​	=COUNTIF(Sheet1!$B$2:$B$10000,Dashboard!G3)​
Argentina​	=COUNTIF(Sheet1!$B$2:$B$10000,Dashboard!G4)​
Australia​	=COUNTIF(Sheet1!$B$2:$B$10000,Dashboard!G5)​

 

[Sufiyan97]

Remove this part from formula
Dashboard!

=COUNTIF(Sheet1!$B$2:$B$10000,Dashboard!G2)

and use

=COUNTIF(Sheet1!$B$2:$B$10000,G2)

 

[Joneye]

Remove this part from formula
Dashboard!

=COUNTIF(Sheet1!$B$2:$B$10000,Dashboard!G2)

and use

=COUNTIF(Sheet1!$B$2:$B$10000,G2)

Thank you, worked perfectly.

 

[Sufiyan97]

You're welcome!
Glad I could help.