Use the SUMIFS function to add different numerical values specified by a set of conditions or criteria. For example, in our example, we will sum all those values which are greater than 100 and smaller than 200.
Follow these steps to get the desired result:
1– Select any cell, type ‘=SUMIFS’ and press ‘tab’ button to select the formula.
2– Select the range of cells to sum i.e. C4:C10.
5– Now 2nd criteria (i.e. sum value smaller than 200) range will be selected.