❮ Previous Next ❯

Basic Excel Functions

  • Learn essential Excel functions for performing calculations.

  • SUM Function

    Purpose: Adds up numbers in a range of cells.

    Syntax:

=SUM(number1, number2, …)

  • Example:

    Sales

    1000

    2000

    1500

=SUM(B2:B4) → 4500

  • Tip: Use SUM instead of manually adding numbers to avoid errors.


    AVERAGE Function

    Purpose: Calculates the average of numbers.

    Syntax:

=AVERAGE(number1, number2, …)

  • Example:

    Sales

    1000

    2000

    1500

=AVERAGE(B2:B4) → 1500

  • Tip: Ignores empty cells automatically.


    COUNT Function

    Purpose: Counts the number of numeric entries in a range.

    Syntax:

=COUNT(value1, value2, …)

  • Example:

    OrderID

    101

    102


    103

=COUNT(A2:A5) → 3

  • Tip: To count all non-empty cells (text + numbers) use COUNTA().


    MIN & MAX Functions

    Purpose: Finds the smallest or largest value in a range.

    Syntax:

=MIN(range)
=MAX(range)

  • Example:

    Sales

    1000

    2000

    1500

=MIN(B2:B4) → 1000
=MAX(B2:B4) → 2000

  • Using Functions in Real Data

    Imagine a Sales dataset:

    Region

    Sales

    North

    1000

    South

    2000

    East

    1500

    West

    1800

    • Total Sales → =SUM(B2:B5) → 6300

    • Average Sales → =AVERAGE(B2:B5) → 1575

    • Count of Sales → =COUNT(B2:B5) → 4

    • Highest Sale → =MAX(B2:B5) → 2000

    • Lowest Sale → =MIN(B2:B5) → 1000

    Tip: Functions make large datasets easy to summarize.

❮ Previous Next ❯