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.
Posting Komentar
0Komentar