Excel Functions: SUM, AVERAGE, MIN, MAX & COUNT
Functions are ready-made formulas in Excel. In this chapter, you will learn how to use common functions to calculate totals, averages, highest values, lowest values and count of numeric records.
SUM
Adds all values in a selected range.
AVERAGE
Calculates the average of numeric values.
MIN
Finds the lowest value in a range.
MAX & COUNT
Finds highest value and counts numeric cells.
After This Chapter, You Will Be Able To
This chapter helps you use ready-made Excel functions confidently.
Use SUM
Calculate totals from a selected range of numbers.
Use AVERAGE
Find average marks, sales, fees or attendance.
Use MIN/MAX
Find lowest and highest values in data.
Use COUNT
Count numeric entries in a selected range.
What is an Excel Function?
A function is a ready-made formula created to perform a specific calculation.
1 Easy Explanation
Excel functions save time by performing common calculations automatically. Instead of adding many cells one by one, you can use a function like SUM to calculate the total quickly.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Name | Word | Excel | PPT | Internet | Total |
| 2 | Amit | 75 | 82 | 79 | 88 | =SUM(B2:E2) |
| 3 | Priya | 88 | 91 | 84 | 90 | =SUM(B3:E3) |
Five Important Excel Functions
These functions are used in almost every Excel job.
Total
Adds numbers in a selected range.
Average
Calculates mean value of selected numbers.
Lowest
Finds the smallest number in a range.
Highest
Finds the largest number in a range.
Count
Counts numeric values in a range.
How to Write These Functions
Every function starts with an equal sign and uses a cell range.
| Function | Syntax | Meaning | Office Example |
|---|---|---|---|
| SUM | =SUM(B2:B10) | Adds all numbers from B2 to B10 | Total fees collected |
| AVERAGE | =AVERAGE(C2:C10) | Finds average of values | Average marks or sales |
| MIN | =MIN(D2:D10) | Finds smallest value | Lowest marks or lowest sale |
| MAX | =MAX(E2:E10) | Finds largest value | Highest marks or highest sale |
| COUNT | =COUNT(F2:F10) | Counts numeric entries | Count of students with marks entered |
Using Functions in a Student Marksheet
Functions make marksheet work fast and accurate.
| Task | Function | Example Formula |
|---|---|---|
| Total marks of one student | SUM | =SUM(B2:E2) |
| Average marks of one student | AVERAGE | =AVERAGE(B2:E2) |
| Lowest marks in a subject | MIN | =MIN(B2:B10) |
| Highest marks in a subject | MAX | =MAX(B2:B10) |
| Count of entered marks | COUNT | =COUNT(B2:B10) |
Where These Functions Are Used
These functions are useful in institutes, shops, offices and businesses.
Fee Collection
Use SUM to calculate total collected amount.
Marksheets
Use SUM and AVERAGE for total and average marks.
Sales Reports
Use MAX and MIN to identify top and low sales.
Stock Records
Use COUNT to count numeric stock entries.
Attendance
Use functions to calculate totals and averages.
Example: Marksheet Calculation
Functions make marksheet calculations quick and reliable.
Manual Calculation
Priya: 88 + 91 + 84 + 90 = 353
Rahul: 65 + 70 + 72 + 68 = 275
Problem: Manual calculation takes time and may create errors.
Function-Based Calculation
| Name | Word | Excel | PPT | Internet | Total |
|---|---|---|---|---|---|
| Amit | 75 | 82 | 79 | 88 | =SUM(B2:E2) |
| Priya | 88 | 91 | 84 | 90 | =SUM(B3:E3) |
| Rahul | 65 | 70 | 72 | 68 | =SUM(B4:E4) |
| Highest Total | =MAX(F2:F4) | ||||
Understand Function Results
Click each function to see its meaning and sample result.
Function Example
Select any function above to see its formula, use and result.
Create a Student Marksheet Using Functions
Complete these steps inside MS Excel.
Office Task: Function-Based Marksheet
Mistakes Students Should Avoid
Functions are easy, but wrong ranges create wrong results.
Wrong Habits
- Forgetting equal sign before function.
- Typing function name incorrectly.
- Selecting wrong cell range.
- Using COUNT for text values and expecting text count.
- Not checking copied formulas.
- Mixing blank cells inside important data range.
Correct Habits
- Always start functions with = sign.
- Write function name correctly.
- Select the correct range carefully.
- Remember COUNT counts numeric values.
- Check formula after copying.
- Keep data range clean and complete.
Quick Quiz
Select the correct answers and check your score.
1. An Excel function is:
2. Which function adds values?
3. Which function calculates average?
4. Which function finds the lowest value?
5. Which function finds the highest value?
6. COUNT function counts:
7. Correct SUM syntax is:
8. In =AVERAGE(B2:E2), B2:E2 is called:
9. Which is a common function mistake?
10. Best function habit is:
Remember These Points
Revise these before moving to Chapter 18.
Function
A ready-made Excel formula used for a specific calculation.
SUM
Adds all numbers in a selected range.
AVERAGE
Finds the average of selected numeric values.
MIN and MAX
MIN finds lowest value and MAX finds highest value.
COUNT
Counts numeric entries in selected range.
Next Step
Now learn sorting and filtering data in Excel.