Step-by-Step 1 – Using the SUMIF Function

If you leave the Sum_range blank, Excel sums the cells you enter in the Range box. You now applied your criteria to sum all values that are greater than $200,000. In your workbook, cells in column C are not highlighted and the text and amount in cells C19, E19, and E20 are empty. Figure 10-2 has been modified to show you which cells in the C5:C16 range meet the >200000 criteria (275,000 ... ................
................