Lesson 08 - SUM, AVERAGE & COUNT

📘 Excel Functions Kya Hote Hain?

Hindi: Excel mein ready-made formulas ko Functions kaha jata hai. Functions calculation ko fast aur easy banate hain.

English: Functions are predefined formulas in Excel that help perform calculations quickly.

=SUM(A1:A5)
=AVERAGE(A1:A5)
=COUNT(A1:A5)

➕ SUM Function

Hindi: SUM function ka use numbers ka total calculate karne ke liye kiya jata hai.

English: The SUM function is used to calculate the total of numbers.

Syntax:

=SUM(A1:A5)

Yahan A1 se A5 tak ke sabhi numbers ka total calculate hoga.

📊 SUM Example

Maan lijiye sales data mein ye amounts hain:

A1 = 1000
A2 = 2000
A3 = 1500
A4 = 2500

Formula:
=SUM(A1:A4)

Result = 7000

💼 Business mein SUM

Business mein daily ya monthly sales ka total calculate karne ke liye SUM function bahut useful hai.

Monday ₹5,000
Tuesday ₹7,000
Wednesday ₹6,000
Thursday ₹8,000

=SUM(B2:B5)

Total Sales = ₹26,000

📈 AVERAGE Function

Hindi: AVERAGE function ka use numbers ka average calculate karne ke liye hota hai.

English: The AVERAGE function calculates the average value of selected numbers.

Syntax:

=AVERAGE(A1:A5)

📊 AVERAGE Example

A1 = 10
A2 = 20
A3 = 30

Formula:
=AVERAGE(A1:A3)

Result = 20

Excel selected numbers ka average automatically calculate karta hai.

💰 Sales Average

Business mein average daily sales calculate karne ke liye AVERAGE function use kiya ja sakta hai.

Monday ₹5,000
Tuesday ₹7,000
Wednesday ₹6,000

=AVERAGE(B2:B4)

Average Sales = ₹6,000

🔢 COUNT Function

Hindi: COUNT function selected range mein kitne numeric values hain, ye count karta hai.

English: The COUNT function counts how many cells contain numbers in a selected range.

Syntax:

=COUNT(A1:A10)

📋 COUNT Example

A1 = 100
A2 = 200
A3 = 300
A4 = Rahul
A5 = 500

Formula:
=COUNT(A1:A5)

Result = 4

COUNT text ko count nahi karta. Sirf numeric values count hoti hain.

⚖️ SUM vs AVERAGE vs COUNT

SUM
→ Total calculate karta hai.

AVERAGE
→ Average calculate karta hai.

COUNT
→ Numbers ki quantity count karta hai.

👨‍💼 Employee Salary Example

Employee salary data mein in functions ka use:

Employee Salary
Rahul ₹25,000
Amit ₹30,000
Priya ₹35,000
Mohit ₹28,000

Total Salary:
=SUM(B2:B5)

Average Salary:
=AVERAGE(B2:B5)

Number of Salaries:
=COUNT(B2:B5)

⚠️ Important Note

SUM, AVERAGE aur COUNT Excel ke bahut important functions hain.

Ye functions sales, salary, expenses, employee data aur business reports mein frequently use kiye jate hain.

🎓 Lesson Summary

Is lesson mein humne seekha:

✅ Excel Functions
✅ SUM Function
✅ SUM ka Syntax
✅ Sales ka Total
✅ AVERAGE Function
✅ Average Calculation
✅ COUNT Function
✅ Numeric Values Count Karna
✅ SUM vs AVERAGE vs COUNT
✅ Business Examples