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*