=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

thanks for the effort

1- not all the member of the EU use the euro (UK is a clear example)
2- let's make it general: i have a list1 (shorter) and a list2
(longer): which is the formula i can use tho determine how many
element of list2 are also in list1?

this is somehow a followup of my question of last night, if i dont
fail you also replied

thanks!



On Aug 14, 11:53 am, "Bob Phillips" wrote:
=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

That is not what I said. I am well aware that the UK doesn't use the Euro, I
personally spend pounds sterling.

You asked for ... Is there a formula like count those countries in the
range2 (the countries of the EU) that belong also to range 1 (countries
having adopted the Euro).

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

That is, the countries in range 1 are the list that you want, so just count
range1 QED

--
HTH

Bob

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

"lorenzo" wrote in message
...
thanks for the effort

1- not all the member of the EU use the euro (UK is a clear example)
2- let's make it general: i have a list1 (shorter) and a list2
(longer): which is the formula i can use tho determine how many
element of list2 are also in list1?

this is somehow a followup of my question of last night, if i dont
fail you also replied

thanks!



On Aug 14, 11:53 am, "Bob Phillips" wrote:
=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

you're right, i apologize.

that's the reason i like to make it more general ("list_long"
"list_short")

On Aug 15, 11:11 am, "Bob Phillips" wrote:
That is not what I said. I am well aware that the UK doesn't use the Euro, I
personally spend pounds sterling.