Thanks for the correction.

In article ,
Bumblebee wrote:

Thank you. Just one thing, it worked only when I stuck a 2 after ISIN_range.
Like this:
=sum(if(left(ISIN_range,2)="ES",other_range,0)