Excel FunctionsLesson 112Free preview
SUMIFS
This lesson is part of Excel · All levels
Summary
SUMIFS is an Excel function that sums values based on several criteria at once. Unlike SUMIF, the sum_range on SUMIFS is written as the first argument. All the criteria must be met (logic AND) to get the value added.
Key points
- Syntax: SUMIFS(sum_range, criteria_range1, criteria1, ...)
- The sum_range is in the first argument, as opposed to the sum_range
- All pairs of criteria range should be the sum_range size
- The text, the numbers, the dates, and the logical criteria are all supported
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.