SUMIFS adds values whose corresponding entries satisfy all specified criteria pairs.
Quick Example
=SUMIFS(Sum Range, Criteria Range 1, Criteria 1, ...)
- Sum Range: The corresponding cell that is to be summed, if the criteria is true
- Criteria Range 1: Range of cells that houses the (first) criteria
- Criteria 1: The (first) criteria to be flagged
These conditional functions evaluate criteria when calculating their result.
- Other examples include: COUNTIFS, AVERAGEIFS, MAXIFS, and MINIFS
Use COUNTIFS or SUMIFS when you need one or more criteria pairs. COUNTIF and SUMIF remain valid for single-condition tasks; check the argument order for the function you choose.
Learn More About Excel
Master Excel through our hands-on Microsoft Office classes and NYIM Excel classes. Sign up and start creating smart and efficient spreadsheets today!