try this

=COUNTIF(A1:A9,"gb")

mike

"andreashermle" wrote:

Dear Experts:

I got a field / column in a table with different values (country
codes):

COUNTRY
ES
EN
FR
FR
DE
EN
US
GB
GB


I now would like to find out how many times the different values have
been entered such as:

ES 4
EN 5
DE 1
GB 7
US 8
etc.

Help is much appreciated. Thank you very much in advance. Regards,
Andreas