Forum Discussion
SUMIF help??
Hello, to keep it short I'm having some problems with the SUMIF function, my excel is in french so you might see it as SOMME.SI. I basically want to calculate the total price of the equipment that ha...
HansVogelaar Thank you for your help. I ended up finding the problem right after I posted the question. The criteria in my sumif was "oui" but in my column A the values were "oui ", notice the extra space. I fixed by adding the space to my creteria. Also the values from column G were just numbers at the beginning, not text, and the dollar sign got added when I changed the format of those cells to finances.
Glad you found it.