I'm trying to use the SUMIF formula, to count the number of cells, that have a specific text, in them, in French (which is SOMME.IF).

No matter what I do it keeps returning a value of 0 cells.

However, when I include the third field, it does add up the values, from the correct cells.

Can some kind person, talk me through this, please?