=COUNTA(range1)

If it has the Euro as its currency, it is de facto a member of the union is
it not?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"lorenzo" wrote in message
...
hi

if I have to named ranges of cell
range 1 has for example the list of countries that adopted the euro as
currency
in the range 2 i have the list of countries that are member of the
European Union.

Is there a formula like
count those countries in the range2 that belong also to range 1
?
thanks