BrounStack
Learning›Excel Tutorial›Basic Functions
CHAPTER 4 · EXCEL FUNCTIONS

Basic Functions: SUM, AVERAGE, MIN, MAX & COUNT

Functions ready-made calculation tools hain. Instead of long arithmetic formulas, structured functions use karke sheet readable aur maintainable banti hai.

English + HinglishBeginnerDirect Lab practice

SUM

Range ka total nikalne ke liye:

FormulaExcel
=SUM(B2:B6)

AVERAGE

Numeric values ka arithmetic mean:

FormulaExcel
=AVERAGE(B2:B6)

MIN aur MAX

MIN smallest numeric value aur MAX largest numeric value return karta hai.

Formula examplesExcel
=MIN(B2:B6)
=MAX(B2:B6)

COUNT

COUNT range me numeric cells count karta hai. Text-filled cells count karne ke behavior ke liye later COUNTA aur COUNTIF cover karenge.

FormulaExcel
=COUNT(B2:B20)
Function anatomy

=SUM(B2:B6) me SUM function name hai aur B2:B6 argument/range hai. Parentheses function arguments ko hold karte hain.

Manual addition vs SUM

=B2+B3+B4+B5+B6 result de sakta hai, but larger ranges me =SUM(B2:B6) clearer aur easier to maintain hota hai.

Common mistakes

  • Range end cell galat select karna
  • Text values ko number samajhna
  • Function name ke baad parentheses bhoolna
  • Colon : aur comma separators ko confuse karna

Practice — Marks analysis

  1. B2:B4 me 70, 80, 60 enter karo.
  2. B5 me total ke liye SUM use karo.
  3. Average calculate karo.
  4. Highest aur lowest marks find karo.
  5. Numeric entries COUNT se count karo.

Open Excel Lab challenge set →

← FormulasNext: Sort, Filter & Tables →