We can sum a data set with a specified criterion using the SUMIF function. The criteria could be for values to sum if greater than or sum if less than a number. This tutorial would teach us how to sum values if they are greater than or less than a specified value.

Figure 1: SUMIF greater than or less than 0

Setting up the Data

  • We will prepare a table of data

Figure 2: Table of Data

  • We will now click on Cell C4 to type the formula =SUMIF(B4:B10, “>0”)0 specifies that all numbers greater than 0 within the range B4:B10 is summed.

Figure 3a: Formula for SUMIF values greater than 0

  • We will now press the enter key

Figure 3b: Answer for the SUMIF values greater than 0

  • Also, we will create a column for SUMIF less than 0 by typing this formula =SUMIF(B4:B10,”<0″) into Cell D4 This will sum the values less than 0

Figure 4a: Formula for SUMIF values less than 0

  • We will now press the enter key

Figure 4b: Answer for SUMIF values less than 0