SUMIF returns no value

[EricB]

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

 

[tompl]

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

 

[Fred Smith]

See your other post.

Regards,
Fred