SUM, SUMIF, and SUMIFS are essential Excel functions used to automate calculations. They are widely used in reporting, data analysis, finance, and administration.
This guide explains each function in a simple, complete, and easy-to-understand way.
1. SUM Function
Definition
Used to add all values in a selected range.
Formula:
=SUM(range)
Example:
=SUM(A1:A10)
2. SUMIF Function
Definition
Adds numbers based on one specific condition.
Formula:
=SUMIF(criteria_range, criteria, sum_range)
Example:
=SUMIF(B2:B20, "Laptop", C2:C20)
3. SUMIFS Function
Definition
Adds numbers based on multiple conditions.
Formula:
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)
Example:
=SUMIFS(C2:C20, B2:B20, "Laptop", A2:A20, "January")
Key Notes
- SUM = No criteria
- SUMIF = One criteria
- SUMIFS = Multiple criteria
- Range sizes must be the same
- Text criteria must use quotes
By understanding SUM, SUMIF, and SUMIFS, you can work faster and more efficiently in Excel. These functions are the foundation for more advanced data analysis.
