Menu
EXCEL SUMIFS FUNCTION
Excel SUMIFS Function Introduction
This function will add cells that meet several criteria.
Description of Excel SUMIFS Function
Syntax:
=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], …)
Parameter list:
- sum range – The range to be added.
- range1 – The first range to be evaluated.
- range2 – [optional] the second range to assess.
- criteria1 – The criterion to apply to range1.
- range2 – The second range to examine (optional).
- criteria2 – [Optional] the range2 criterion
Unlike the SUMIF function, the SUMIFS function may examine many sets of criteria at the same time.
Step By Step Guide of SUMIFS Function
The first parameter will be added together. The criteria are to be presented in pairs, with the first pair being required and the remaining pairs being optional. Up to 127 range/criteria pairs can be entered.
Key Points
Using wildcard characters in criteria1 and criteria2 such as the question mark (?) and asterisk (*) might help you locate matches that are similar but not precise.
A question mark corresponds to any single character. Any character sequence is matched by an asterisk. To discover a genuine question mark or asterisk, insert a tilde () before the question mark.
The sum range must have the same number of rows and columns as each higher ultimate.
Non-numeric criteria must be surrounded by double quotes, whereas numeric criteria do not.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
