To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use the SUMIF Function to sum all of the values greater than a specified value. We will also use a named range to demonstrate how this can used in place of a standard range of cells


Syntax Explanation:

  • range – Range of cells that you want to apply the criteria against.
  • criteria – Criteria used to determine which cells to add. This can be in the form a number, expression, text, or function.

Usage Demonstration

Let’s look at the following data set. We want to sum all of the value greater than 0. This is achieved by using the following formula.

Sum if greater than

Sum if greater than with Named Range

In this example, we will use a named range to instead of defining the cell range. This is done by creating a Named Range. The easiest way this is achieved is to highlight your range of cells, or cell, then enter a name in the box next to the formula bar. Please note that this name must not contain any spaces. For a complete understanding, refer to the named range tutorial.

Once named, we can use “Sales_dollars” in our formula as shown.

Sum if greater than named range

Leave a Reply

XLOOKUP Function in Excel

XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!

Read More »

Autosum Function

Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just

Read More »
Scroll to Top