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