Rank function using "array IF" formula as ref doesn't seem to work

Hi,

Please see my example workbook
Rank example workbook.xlsx
I'm trying to rank a city's score based on the scores of global cities and the european cities from within the same table. For the european ranking I've done a column with "European city?" yes/no so I thought I could use
"{=RANK(D$10;IF($C$4:$C$33="Yes";D$4:D$33))}" (see cell D3)
But that gives a #VALUE error since RANK() doesn't seem to be able to handle the "FALSE" output from the boolean array created by the IF formula.
Is there anyway of sorting this out? Or do I have to make a separate table with only European cities for this to work?

Thanks for your help!

Thanks XOR LX,

I figured out two other ways that I like even more:
(array formula)

Please Login or Register  to view this content.

and

(not array formula)

Please Login or Register  to view this content.