Tackle 2024 with new knowledge – take advantage of Learnesys’ fall campaign on the All Courses package. Read more here.


The SUMIF function sums up the numbers in a range of cells that agree with a certain condition.
In our example, we only want to sum up the numbers that are greater than 10.
This will require 2 arguments, the range… and the condition, which is “greater than 10”.

We can see that the sum of the numbers in the range that are greater than 10, is 103.

In this lesson we have shown the function for summing up numbers given a condition.