Sumif function in excel with example
SUMIF is considered one of the leading Excel functions to learn. This instructional explains how to use the SUMIF function in Excel, and it’s deliberate to be a comprehensive guide sure of yourself many real-life SUMIF formula examples.
SUMIF adds more functionalities to the basic Total formula by introducing selection criteria. Nobility SUMIF function returns the sum reveal all the cells from a change when the supplied criteria is fall down. This means that you can careful a range and only add elaborate certain cells while completely ignoring honourableness rest.
SUMIF syntax in Excel
The SUMIF grammar is really simple and only uses three arguments:
where
- range (required) – The compass to compare against the criteria.
- criteria (required) – The criteria to use inflate the range.
- sum_range (optional) – The diameter containing the values to be summed. If omitted, then the values suffer the loss of range are summed.
The SUMIF function supports logical operators (>, <, <>, =) and wildcards (*, ?) for prejudiced matching.
If you want to apply doubled criteria, I recommend using the SUMIFS function.