SUM, AVERAGE, and COUNT are the most commonly used basic functions in Excel. They help you quickly calculate totals, averages, and the number of entries in your data.
1. SUM Function
The SUM function adds numbers together.
Structure:
=SUM(range)
Example:
=SUM(A1:A10)
This formula adds all values from cell A1 to A10.
You can also add individual cells:
=SUM(A1, B1, C1)
When to Use SUM:
- Calculate total sales
- Add student marks
- Find total expenses
2. AVERAGE Function
The AVERAGE function calculates the mean (average) of numbers.
Structure:
=AVERAGE(range)
Example:
=AVERAGE(A1:A10)
This calculates the average of values from A1 to A10.
When to Use AVERAGE:
- Calculate average marks
- Find average monthly sales
- Analyze performance data
3. COUNT Function
The COUNT function counts only cells that contain numbers.
Structure:
=COUNT(range)
Example:
=COUNT(A1:A10)
This counts how many cells in A1 to A10 contain numeric values.
Important:
- COUNT ignores text.
- COUNT ignores empty cells.
Related Functions (Bonus)
- COUNTA → Counts non-empty cells (text and numbers).
- COUNTBLANK → Counts empty cells.
Simple Example
If cells A1 to A5 contain:
10
20
30
40
50
Then:
- =SUM(A1:A5) → 150
- =AVERAGE(A1:A5) → 30
- =COUNT(A1:A5) → 5
Why These Functions Are Important
They help you:
- Perform quick calculations
- Analyze data easily
- Create reports efficiently
- Save time
SUM, AVERAGE, and COUNT are the foundation of Excel formulas and are essential for every beginner to master.