SUM, AVERAGE, COUNT, MIN, MAX

Last reviewed Jun 1, 2026 Content v20260601

Track mode

none

Means

Read / quiz

Reading

~1 min

Level

beginner

This lesson

This lesson teaches SUM, AVERAGE, COUNT, MIN, MAX: Excel concepts, formulas, and analysis patterns you recreate locally in a workbook.

Teams apply SUM, AVERAGE, COUNT, MIN, MAX in every serious Excel workflow—skipping it leaves errors in models stakeholders trust.

You will apply SUM, AVERAGE, COUNT, MIN, MAX in contexts like: Finance, operations, reporting, and quick what-if analysis before a full BI stack.

Read the lesson, type formulas in your local Excel or compatible spreadsheet, rebuild examples in excel-practice.xlsx, and complete MCQs—no in-browser runner.

When you can explain the previous lesson's ideas in your own words.

Aggregate functions are the backbone of reporting—always confirm whether Excel is counting numbers only or including text.

Functions

=SUM(B2:B100)
=AVERAGE(B2:B100)
=COUNT(B2:B100)      ' numbers only
=COUNTA(B2:B100)     ' non-empty cells
=MIN(B2:B100)
=MAX(B2:B100)

AutoSum

Alt+= inserts SUM for adjacent range.

SUBTOTAL

=SUBTOTAL(9, range) ignores rows hidden by filter—useful in filtered tables.

Important interview questions and answers

Q: COUNT vs COUNTA?
A: COUNT counts numbers; COUNTA counts non-empty.
Q: SUBTOTAL?
A: Respects filtered rows.

Self-check

Difference COUNT vs COUNTA?
When use SUBTOTAL?

Pitfall: SUM skipping text numbers—clean data types first.

Interview prep

COUNT vs COUNTA?: COUNT numbers only; COUNTA any non-empty cell.

Discussion

Past discussion is visible to everyone. Only logged-in users can post comments and replies.

Starter discussion topics

COUNT vs COUNTA?
SUBTOTAL with filter?

No discussion yet. Be the first to ask a question.