What is the formula in google spreadsheets?

Question

Google Sheets

Hello! Help me please. We need a formula in Google spreadsheets that will display the number of cities from column G to column H into a number. Here is a link to the spreadsheet:
https://docs.google.com/spreadsheets/d/1bLA-GBa8zL...
Tell me , what formula do you need? I try COUNT, but it does not work correctly.

Answer 1

You can use =COUNTA(G2:G)-1, since an empty value is also a value. But in general COUNTUNIQUE(G2:G) will be better, then a column without repetitions is not needed

Answer 2

=COUNTA(G1:G1000)