# How to Use SUMIF Function | Microsoft Excel

How to Use SUMIF Function | Microsoft Excel

Sumif Function is used when calculate sum of the specific a limited criteria of the data. For Example we have a data from 1 to 10 and we want sum of the number which are less than five then sumif ignores the other numbers which are greater than 5.

### Syntax of SUMIF Function

=SUMIF(range,criteria,[sum_range])

### Arguments of SUMIF Function

range: required. a range in which you want to perform the operation. range should contain numbers other than value will not consider to sum.
criteria: required. criteria is a logical operation. as per the criteria is satisfied in the range sumif will returns a result. Criteria should be number, text, reference, expression. Text or special characters should be in double quote(“text”)
sum_range: optional. if you wnat another range from the range you specified to satisfy the criteria.

#### Wild Card Characters:

? for matching any single character
* for matching any sequence of character
~  to find actual wild card character(? or *) us tild(~) preceding the character

### Behaviour of  SUMIF Function

#### For Numerical

=SUMIF(A1:A8,”<20″) will sum the numbers which are less than 20 in the column A1:A8

#### For Text

=SUMIF(A1:A8,”Jaguar”,B1:B8) will sum the number in range of the A1:A8 contains Jaguar

### Use of SUMIF Function

To calculate the number as per the criteria defined

### Return of the SUMIF Function

The sum of the numbers