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