MSK Institute • Shikohabad
Loading Page Content...
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Connecting serverPlease wait...
💻 Practical Labs🚀 Free Demo📜 Verified Certificates
SUM, AVERAGE, MIN, MAX Functions0%
SUM, AVERAGE, MIN, MAX Functions
Beginner12 min read•Updated: Jul 11, 2026
SUM, AVERAGE, MIN, MAX Functions
Functions are pre-packaged mathematical algorithms built directly into Excel. While simple arithmetic (=A1+B1) works for two numbers, functions allow you to summarize thousands of rows with a single parameter range.
Click to Zoom1. The SUM Function
Adds all individual numbers, cell references, and multi-column ranges:
=SUM(number1, [number2], ...)
- Single Range:
=SUM(B2:B25)(Adds all cells between B2 and B25). - Multiple Disconnected Ranges:
=SUM(B2:B10, D2:D10, F5)(Separated by commas). - Entire Columns:
=SUM(B:B)(Adds every value in column B, automatically incorporating new rows as they are added).
2. The AVERAGE Function
Computes the mathematical arithmetic mean (sum divided by count) of a dataset:
=AVERAGE(C2:C50)
Crucial Rule on Blank Cells vs. Zeros:
-
AVERAGE ignores completely blank cells. If you have 4 tests with scores (100, 100, 100, and blank), the average is 300 / 3 = 100.
- If you enter a literal number 0 in the fourth cell, AVERAGE includes the zero: 300 / 4 = 75! Always be mindful when entering zero vs. leaving a cell empty.3. The MIN and MAX Functions
Locates extreme values in any numerical dataset:
- MIN: Returns the smallest numerical value in the range.
=MIN(D2:D100)
- MAX: Returns the largest numerical value in the range.
=MAX(D2:D100)
- Use Cases: Finding the lowest product price, oldest invoice date, highest test score, or peak daily revenue.
4. COUNT vs. COUNTA (Counting Cells)
A frequent point of confusion for spreadsheet users:
- COUNT: Counts only cells that contain NUMBERS. It completely ignores text words, blanks, and errors.
=COUNT(A2:A100)
- COUNTA ("Count All"): Counts any cell that is not empty. It tallies numbers, text labels, codes, and dates (great for counting how many employee names are in an attendance roster!).
=COUNTA(A2:A100)
- COUNTBLANK: Counts the number of empty, blank cells in a range.
Interactive Quiz
Multiple Choice Questions
Question 1
What does the formula =AVERAGE(B2:B5) return if cells B2, B3, and B4 contain the number 30, and B5 is completely blank?
Question 2
Which function counts only cells containing numeric values while ignoring text labels?
Question 3
Which formula correctly finds the highest sales revenue figure in the range C2 through C50?
Question 4
How can you sum two non-adjacent cell ranges (such as Column B and Column D) inside a single SUM function?
Question 5
What function counts how many customer order rows have missing, blank shipping address cells?
Next Lesson
Basic Text Functions (CONCATENATE, UPPER, LOWER)
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
Related Lessons
| Previous Lesson | Next Lesson |
|---|---|
| AutoSum and Status Bar Calculations | Basic Text Functions (CONCATENATE, UPPER, LOWER) |
Practice Quiz
Test your understanding of this lesson with 5 questions. Each question has one correct answer.