**SUMIF** is the function that is used to calculate a sum of values in a range that satisfies a specific condition you specify instead of calculating the sum of an entire range.

In other words, it is the combination of SUM and IF function. it adds all numbers in a range of cells based on criteria. Learn how to use the SUMIF function here.

Note:-Before starting any Formula or Function you need to add (=)

### Syntax:- =SUMIF(range, criteria, [sum_range])

## How to Use SUMIF Function in Excel

### Text Criteria

Use the SUMIF function in Excel to sum cells or a range of cells based on texts that meet the given criteria.

In the above example, we have multiple cities in the city column ( A ) with duplicates. and we want to get the total value of each city in ( E ) column.

To get the total value of each city, you can also use the addition formula in Excel. but it is a time consuming process.

In this kind of scenario, you can use the SUMIF Function in Excel. here it calculates a sum of value in a range, with city name condition.

The SUMIF function sums values in the range A2:A10 with corresponding names in D2:D6

After applying the formula I have used an absolute reference to drag the formula to all the cells.

And the Result is

### Numeric Criteria

Use the SUMIF function in Excel to sum cells or a range of cells based on numbers that meet the given criteria.

In the above example, we have a city column ( H ) with values in column ( I ). And the condition is, we need to get the total value of cities that have more than 1000 values in the I12 cell.

To get this i have applied the formula =SUMIF(I2:I10,">=1000").

That means the SUMIF function sums cells that have greater than 1000 value in range I2:I10.

## Download