Skip to content

How to Use the SUMIF Function

When it comes to adding numbers, a spreadsheet is one of the best tools available. When it comes to logic, a spreadsheet comes in handy once again.

How about when you put adding and logic together? Once again, a spreadsheet has you covered. Enter the SUMIF function!

The SUMIF Function

The SUMIF function allows you to sum the cells in a spreadsheet that meet a given condition.

For example, if you have a list of prices and would like to add up only the prices greater than $10, then you would use the SUMIF function.

The SUMIF function also allows you to sum the cells in a range based on another range of equal size. To understand this, let’s look at how the SUMIF function works.

How the SUMIF Function Works

The SUMIF function requires at least two arguments to work and sometimes three.

=SUMIF(range, criteria, [sum_range])

If the range being tested is also the range to be summed, the SUMIF function only requires two arguments.

=SUMIF(range, criteria)

All cells that meet the criteria will be summed.

However, if the criteria is evaluated on a different range (one that is not summed), the SUMIF function requires three arguments.

=SUMIF(range, criteria, sum_range)

The SUMIF function will check to see which cells in the range meet the criteria. The SUMIF function will then add together the cells in the sum_range that are in corresponding positions to those cells in the first range which meet the criteria.

Take a look at this example.

The SUMIF is looking for the value “North” in the first range.

The SUMIF function then adds together the cells in the sum range that are in the same row (corresponding position) as those cells containing the value “North.”

How to Use the SUMIF Function

Here are two examples showing how to use the SUMIF function.

The first example illustrates how to use the SUMIF function with only two arguments.

=SUMIF(A1:A8,">10")

In the example below, the SUMIF function is used to add together the cells containing a value greater than 10.

The second example shows how to use the SUMIF function with three arguments.

=SUMIF(A1:A8,"Blue",B1:B8)

The SUMIF function sums only the cells that correspond with cells containing the text value “Blue.”

And that sums up how to use the SUMIF function.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top