WWorkTools
Learn›Excel›SUM, AVERAGE, MIN & MAX
FOUNDATION

SUM, AVERAGE, MIN & MAX

Calculate totals and basic descriptive statistics.

After this lessonSummarize numeric ranges quickly.

How it works

SUM adds numeric values, AVERAGE calculates the mean, while MIN and MAX return the smallest and largest numeric value. These functions are the fastest way to validate operational totals.

Use ranges instead of long chains such as =B2+B3+B4. Ranges are easier to maintain and expand.

REAL WORK

Total issued quantity, calculate average unit cost or find the largest downtime value.

SYNTAX

The pattern

=SUM(B2:B100)

Example

=SUM(B2:B6)
TRY IT

Test the formula

The sample sheet is local to this page. Change the formula and see the result immediately.

fx
Result
QUICK CHECK

Which function returns the arithmetic mean?

Progress is stored only in this browser. No account required.