Sum if formula returns 0 but should give a different value

[marcvanderpeet1983]

Dear all,

Im using the attached sheet.

Dashboard H2 contains a sumif formula. I believe it's correct but for some reason, it does not return the valid number. Any thoughts on what I am doing wrong?

 

[ETAF]

you have more than 1 column in the criteria
does that mean that Germany for example can appear in countries B, C & D ?

=SUMIF(Countries!$B$3:$B$15,B2,Countries!$D$3:$D$15)

=SUMIF(Countries!$C$3:$C$15,B2,Countries!$D$3:$D$15)

 

[bosco_yip]

Hi,

1] Hidden tailing space CHAR(160) were found both in your Dashboard sheet and Countries sheet.

2] Use a helper column to remove hidden space CHAR(160)

3] Then, use a Sumif function to return the desired result

4] Please see attached file.