Step-by-Step 1 – Using the SUMIF Function

In C21, SUMIF checks for values in column E that are less than 3% (E8 is the first one) and finds the value in the same row and column C (C8 in this case) and adds this to the total. Click . OK . to accept your changes and close the dialog box. Excel returns a value of $1,134,200. 12. SAVE the workbook. PAUSE. LEAVE the workbook open for the next exercise. Step-by-Step 2 – Use the SUMIFS ... ................
................