Step-by-Step 1 – Using the SUMIF Function

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+209,000+258,000+359,500+250,000+305,600) and that the total is the sum of these individual cells or 1,657,100. ................
................