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

## No comments:

## Post a Comment