SUM

Explanation

SUM is used to add numbers from selected cells or ranges.

Syntax

=SUM(number1, number2, …)

Example

Student	Marks
Amit	75
Neha	82
Rahul	68
Priya	91

Total marks:

=SUM(B2:B5)

Result: 316

Real-World Use

• Total sales
• Total expenses
• Total marks
• Total salary
• Total quantity

AVERAGE

Explanation

AVERAGE calculates the arithmetic mean of numbers.

Original amountsEqual shares101010

\(\bar{x} = \frac{10 + 10 + 10}{3} = \frac{30}{3} = 10\)

x̄ is the arithmetic mean (simple average)

\(x_1\)

\(x_2\)

\(x_3\)

Remove valueAdd value

Give feedback

Syntax

=AVERAGE(number1, number2, …)

Example

=AVERAGE(B2:B5)

Result: 79

Practice

Create a marks table for 10 students and calculate:

• Total Marks
• Average Marks