thanks really a lot.

Could you explain me why this formula works? i dont get it
the result of the COUNTIF seems to be an error
and I do not understand what you do with the SUMPRODUCT

and also i dont understand what are those "--" you have after the
first parenthesis

now, going back to the question of last night
imagine i have a database with all the countries of the world
and then have a series of clusters (lists with a bunch of country
names)

i'd like to sumproduct column 7 and column 9 of my database
but only for those countries of the world that belong to cluster1 or
cluster5

how do i do it?

thanks really a lot!


On Aug 14, 12:12 pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
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