Sum if greater than

To sum values greater than a given number, you can use the SUMIF function or the SUMIFS function. In the example shown, cell G5 contains this formula: =SUMIF(D5:D16,">"&F5) With $1,000 in cell F5, this formula returns $7,400, the sum of values in D5:D16 greater than $1,000.

April 14, 2025 · 1 min · 78 words · Gordon Perez

Table of Contents

This problem can be easily solved with the SUMIF function or the SUMIFS function.

SUMIF function

TheSUMIF functionis designed to sum cells based on asinglecondition.

For more SUMIF examples,see this page.

Excel formula: Sum if less than

For more on concatenation,see this page.

The syntax for SUMIFS is similar, but the order of theargumentsis different.

For more SUMIFS examples,see this page.

Excel formula: Sum if between

Criteria can be applied to dates, numbers, and text.

How to use the SUMIF function

How to use the SUMIFS function

Excel formula: Sum if begins with

Excel formula: Sum if not blank

Excel formula: Sum if cells are not equal to

Excel formula: Sum if x or y

Excel formula: Sum if cells contain specific text

Excel SUMIF function

Excel SUMIFS function