ExcelBanter - SUMIF returns no value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF returns no value (https://www.excelbanter.com/excel-worksheet-functions/260641-sumif-returns-no-value.html)

EricB

SUMIF returns no value

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 returns no value

=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

Fred Smith[_4_]

SUMIF returns no value

See your other post.

Regards,
Fred

"EricB" wrote in message
...
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

All times are GMT +1. The time now is 05:23 PM.