📊 Excel Formulas — Part 1

Let’s start with the most important Excel formulas for beginners.

1️⃣ SUM

Adds numbers together.

=SUM(A2:A10)

Example: Calculate total sales from A2 to A10.

2️⃣ AVERAGE

Calculates the average.

=AVERAGE(B2:B10)

Example: Find the average marks of students.

3️⃣ COUNT

Counts cells containing numbers.

=COUNT(A2:A10)

Example: Count how many numeric values are present.

4️⃣ COUNTA

Counts non-empty cells.

=COUNTA(A2:A10)

Example: Count how many customers have been entered.

5️⃣ MAX

Returns the largest value.

=MAX(C2:C10)

Example: Find the highest sales value.

6️⃣ MIN

Returns the smallest value.

=MIN(C2:C10)

Example: Find the lowest sales value.

7️⃣ COUNTBLANK

Counts empty cells.

=COUNTBLANK(A2:A10)

Example: Find how many records are missing data.

8️⃣ PRODUCT

Multiplies numbers together.

=PRODUCT(A2:A5)

Example: Multiply multiple values without writing A2_A3_A4**A5.

💡 Quick Practice

Suppose column B contains:

100, 250, 300, 150, 200

Try to find:

1. Total → SUM

2. Average → AVERAGE

3. Highest value → MAX

4. Lowest value → MIN

5. Number of values → COUNT

Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

Double Tap ❤️ For Part-2