=SUMIF('TB SAICMB'!$A$4:$A$500,$A4,'TB SAICMB'!$S$4:$S$500)

"EricB" wrote:

My SUMIF argument returns no value but when checking fx the Sum_range
reflects the correct value, but Formula result is R €“

=SUMIF($A4,'TB SAICMB'!$A$4:$A$500,'TB SAICMB'!S4)

Any help will be appreciated

EricB