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 has a value of "oui" under the first column called camptabiliser. I don't want to include in the TOTAL the values that have non under the first column. Here is my table with my formula in the highligted cell. =SOMME.SI(A6:A32, "oui", G6:G32)
Can someone tell me what the problem is? Thank you in advance
3 Replies
I suspect that the values in column G are text. Try the following:
Select G6:G33.
Press Ctrl+H to activate the Replace dialog.
Enter $ followed by a space in the 'Find what' box.
Leave the 'Replace with' box blank.
Click 'Replace All'.
If Excel complains that it cannot find the value, delete the space after $ and type Alt+0160 (using the numeric keypad), then try again.
Do you get a non-zero sum now?
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.
