When creating reports, totals and averages are among the most frequently used calculations. Even Excel beginners can use the SUM and AVERAGE functions to create reports twice as fast after reading this article!
β SUM Function β The Basics of Calculating Totals
The SUM function calculates the total of numbers in a specified range.
=SUM(B2:B10)
Example: If sales volume data is entered in B2 through B10, you can calculate the total with the formula above.
β AVERAGE Function β Calculating Averages
The AVERAGE function calculates the average of a selected range.
=AVERAGE(C2:C10)
For example, you can quickly calculate the average for test scores or work performance.
β Practical Tip β Totals and Averages by Condition
To calculate based on a condition, use SUMIF and AVERAGEIF.
=SUMIF(D2:D20, "μμΈ", E2:E20)
This selects only the data labeled βSeoulβ in column D and calculates the total in column E.
β Checklist to Prevent Errors
- Check that blank cells do not contain error values.
- Check for values entered as text instead of numbers.
- Review whether unnecessary rows are included in the total range.
π Summary
- β Total: SUM
- π Average: AVERAGE
- π― Conditional calculations: SUMIF / AVERAGEIF
π Frequently Asked Questions (FAQ)
Q1. Why does the SUM function return only 0?
A. This often happens when values in the range are entered as text rather than numbers.
Q2. Are blank cells included when calculating a total?
A. No, blank cells are automatically ignored.
Q3. How are error cells handled when calculating an average?
A. If there is an error value, the calculation stops, so be sure to clean up your data first.
Totals and averages are core Excel skills! Apply what you learned today directly to your work. Your report creation time will be cut in half π