You will see the result. The other option is to go to the Formulas tab in the function and library group; click Math and Trig. In the drop-down menu, select SUMIF. A function argument dialog box ...

the SUMIF function isn't difficult to use, but the easiest way to see it in action is by adding a range of values based on a criterion in that range. For example, suppose you have a spreadsheet ...

These operations are especially useful in formulas where you're using the IF function ... sum the cells corresponding in order to those in the first argument meeting the criteria. For example ...