SUMIFS

Back to all functions

The Sumifs function sums up the numbers in a range of cells that comply with multiple conditions at once.

In our example, we’ll be summing up the numbers in column B that have the letter C on their row in column C, given that they also have the letter A in column A.
We’ll write SUMIFS, and select the area we want to add up.
We will then need the first condition, which consist of two parts: the range… and the condition. And then we insert the second range… And its condition.

When we are finished, we see that the sum of the numbers that have the letter A and C on their row is 18.
In this lesson, we have gone through the SUMIFS function.