CHAPTER 9 · INTERMEDIATE EXCEL

COUNTIF, SUMIF & AVERAGEIF

Jab calculation sirf matching records par karni ho, conditional aggregate functions bahut useful hote hain. Inse category, score, department ya region ke basis par count, sum aur average nikal sakte ho.

English + Hinglish30 minExcel Lab practice

COUNTIF

count matchesExcel

=COUNTIF(B2:B10,">=50")

Criteria match karne wale cells ka count deta hai.

SUMIF

sum matching rowsExcel

=SUMIF(A2:A10,"East",B2:B10)

A column me East match hone par corresponding B values add hongi.

AVERAGEIF

average matching rowsExcel

=AVERAGEIF(A2:A10,"Sales",B2:B10)

Matching group ka average calculate hota hai.

Criteria tip: Operators text ke andar likhe jate hain, jaise ">=50". Text match ke liye "East" jaisa criteria use hota hai.

Hinglish

Normal SUM sab values add karta hai. SUMIF pehle condition check karta hai aur sirf matching rows ko include karta hai.

Practice

Region-wise sales aur score criteria challenges Excel Lab me solve karo.

Open Excel Lab →