Forum Discussion
polo0814
May 24, 2022Copper Contributor
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...
polo0814
May 25, 2022Copper Contributor
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.
HansVogelaar
May 25, 2022MVP
Glad you found it.