Excel FunctionsLesson 111Free preview
SUMIF
This lesson is part of Excel · All levels
Summary
SUMIF is an Excel function that sums cells in a range based on one particular criterion. The syntax is. If the sum_range argument is passed, the first range becomes the basis of addition.
Key points
- Syntax: SUMIF(rentang, kriteria, [rentang_jumlah])
- The criteria can be numbers, texts, or logical expressions
- The sum_range is optional and is the same size as the range
- Use SUMIFS for adding up to many criteria
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.