Forum Discussion
Criteria check then calculation (sumif or If Then?)
Hello, trying to do the following: If cell in range A is equal to "x" then multiply cell in range B * Cell in range C then add all the results to produce one number. Attempted: =sumif (c2:c117,"x",...
Many thanks that did the trick Riny_van_Eekelen. Question: what is the purpose of the 2 dashes just inside the first parenthesis?
It will convert the list to TRUE or FALSE to evaluate the result. You can use "Evaluate Formula" feature to examine the result. You can find if under Formulas ribbon --> Formula Auditing group --> Evaluate Formula.