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 ‘N’ 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.

SumIF data

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

SUMIF 2


2. Finding the sum of the numbers in a range by passing a condition and a reference range

SUMIF 3

 

Hope it has helped you…       

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply