Anything Look strange with this - using in Office 365 = It is Displaying $0.00 but shouldn't

[jim may]

[TABLE]
<tbody>[TR]
[TD] =SUMPRODUCT((YTD_GOOG_2019_CyberSource!$A$5:$A$500='Monthly  Recons-Google'!C$4)*((YTD_GOOG_2019_CyberSource!$M$5:$M$500="Settlement")+(YTD_GOOG_2019_CyberSource!$M$5:$M$500="Card  Credit"))*(YTD_GOOG_2019_CyberSource!$I$5:$I$500))[/TD]
[/TR]
</tbody>[/TABLE]

 

[jim may]

The Problem is LIKELY that Column M contains multiple text - and I need only those row that contain anywher in the M Cell either the text "Settlement" or "Card Credit".

 

[Eric W]

You may want to check that the values you're looking for match exactly what's in your formula. Some of the values seem to have an unusual number of spaces.