Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.


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.