Step-by-Step 1 – Using the SUMIF Function

In C21, the criteria range is different than the sum range. In C20, the criteria range and the sum range are the same. 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. ................
................