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.
In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...
Looking for something custom made? Contact us and we will make sure to meet your requirements.