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*

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment