SUMIF function

The Excel SUMIF function is a handy tool for adding up values based on a specific condition. It’s like a digital assistant that helps you calculate the total of numbers that meet certain criteria.


=SUMIF(range, criteria, [sum_range])


rangeThe range of cells that you want to evaluate against the given criteria.
criteriaThe condition or criteria that you want to apply to the cells in the range. For example, “>50” means values greater than 50.
[sum_range](Optional) The range of cells from which you want to sum values. If omitted, the function will sum the values in the ‘range’ itself.

How to use

The SUMIF function is simple to use and can be a real time-saver. Here are some examples to illustrate how it works:

Let’s say you have a list of test scores in cells A1 to A5, and you want to find the sum of scores that are greater than or equal to 80:

This formula will add up all the scores in the range A1 to A5 that meet the condition (>=80).

Now, let’s take it up a notch. Suppose you have a list of products in column B (B1 to B10) and their respective sales in column C (C1 to C10). You want to find the total sales for a specific product, let’s say “Apples.” You can use SUMIF like this:

This formula will sum up the sales values in column C where the product name in column B matches “Apples.”

One more example: if you need to calculate the total sales of products with prices above $10, you can use SUMIF with a range of prices in column D (D1 to D10) and a condition:

This formula will add up the sales values from column C where the prices in column D are greater than $10.

So, whether you’re dealing with test scores, product sales, or any other data, the SUMIF function can help you efficiently calculate the sums you need based on specific criteria.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.