Hi Lorenzo

=SUMPRODUCT(--(COUNTIF(range2,range1)))

--
Regards
Roger Govier

"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