**S**uppose 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?*

*1. What is the SUMIF Function?*

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

*2. What is the Syntax?*

*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?*

*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… *