# What Is Excel SUMIF Function – A Complete Guide

Suppose you want to add a few numbers based on certain criteria.

How will you approach it?
I will surely rush back to SUMIF function… 🙂

Let us see how to use it in detail…

1. What is the SUMIF Function?
2. What is the Syntax?
3. How to use it with an example?

#### 1. What is the SUMIF Function?

SUMIF function can be used to add the number of values based on certain criteria, which can be passed as arguments.

#### 2. What is the Syntax?

=SUMIF(range, condition, sum_ range)

• range = (Required) A number, a range of cells which contain numbers or a single cell which contain a number.
• condition = (Required) Condition based on which the addition has to happen.
• sum_range = (Optional) The cells to consider for addition. If sum_range is omitted, then the cells in range are added together instead.

Note :

• The wildcard characters i.e.? and * can be used in criteria.
• It ignores the text values if any in the provided range.
• Conditions with text or any logical operators must be enclosed in double quotes.
• Use “<>” condition for non-black cells and “” condition for blank cells.

#### 3. How to use it with an example?

We have a data set which contains the funding provided by different states from different countries.

Let’s find the amount funded by each country. 1.Finding the sum of the numbers in a range based on a condition.
2.Finding the sum of the numbers in a range by passing a condition and a reference range.

### 1. Finding the sum of the numbers in a range based on a condition ### 2. Finding the sum of the numbers in a range by passing a condition and a reference range Hope it has helped you…