Forum Discussion
Sumifs >=
Renattae_Schmidt So that column C is text. The formula is =RIGHT(B2,3) which returns text. Even though you set the 'formatting' of that column to formatting style called NUMBER it doesn't convert that text to numbers. It is confusing, but it only sets the formatting of actual numbers in that column to a certain format. That said you can fix you issue by simple changing that formula to =--RIGHT(B2,3)
The "--" before the RIGHT performs a multiplication by -1 twice and Excel's Formula Calculator DOES try to convert the text into a value. It is shortcut to the alternative function, which you could also use: NUMBERFORMAT()
I also recommend formatting the table of data as a Table (HOME -> STYLES -> Format as Table) and then use the table structure references so you aren't forcing Excel to look at the whole column of empty values.
In the attached I updated it accordingly and gave examples of both.
Renattae_Schmidt I suspect the issue with the values in column C being text values instead of number values. Try this:
=SUMPRODUCT('Iri Comp Data'!$X:$X * ISNUMBER(SEARCH("Sobeys",'Iri Comp Data'!$O:$O))*('Iri Comp Data'!$S:$S="ON")*(--'Iri Comp Data'!$C:$C >= 200))