← Years 5–6 Data & Information

The COUNT function

A spreadsheet formula that counts how many cells in the range B2 to B10 contain numbers. It ignores cells with text or empty cells.

Part of: 5-6 Digital Technologies Vic Curric - Data, Information and Privacy — Module 27, VCE Applied Computing - U1O1 - Data analysis — Module 13, VCE Data Analytics - U3O1 - Data Analytics — Module 66, VCE Data Analytics - U4O1 - Development and Evaluation — Module 20, 7-8 Digital Technologies: Analysing and visualising data — Module 4, ACARA Digital Technologies Years 7–8 — Acquiring and Storing Data — Module 47, ACARA Digital Technologies Years 7–8 — Analysing and Visualising Data — Module 13

Understanding The COUNT function in Years 5–6 Data & Information

What it does: COUNT with the range D2:D25 counts the number scores, so it shows how many responses were entered. If A1:A5 holds 3 numbers and 2 words, COUNT gives 3 because it ignores the text. COUNT tells you how many cells hold numbers. SUM is the function that adds the numbers together. Every formula must start with an equals sign (=), or the spreadsheet just treats it as plain text. The range B2:B26 covers every response. Using just B26 only looks at a single cell. The colon (:) joins the first and last cells to make a range that includes all the cells in between.

Common mistakes: The closing bracket is missing. A COUNT formula must end with ), so it should be =COUNT(B2:B10). Every formula must start with =. Without it the spreadsheet treats it as plain text. It should be =COUNT(B2:B10).

Class: _____________________ · Name: _____________________ · Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add The COUNT function to a class →

This module's key terms are also in a printable crossword (Modules 21–30) and word search (Modules 21–56).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning

Duo

What does =COUNT(B2:B10) do?

Adds up all the numbers from B2 to B10Counts how many cells from B2 to B10 contain numbers

Matches

COUNT(B2:B10)

↓

The formula is missing the = sign at the start, so the spreadsheet treats it as plain text. It should be =COUNT(B2:B10).

Applying

Meanings

Term

=COUNT(B2:B10)

Meaning

A spreadsheet formula that counts how many cells in the range B2 to B10 contain numbers. It ignores cells with text or empty cells.

Practice

=COUNT(B2:B10)

Testing

Gaps

=(B2:B10)

Check Answer

Spots

1=COUNT(B2:B10

2=COUNT(C2:C10)

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy

Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games

Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print

Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. What does =COUNT(B2:B10) do?

A. Counts how many cells from B2 to B10 contain numbers ✓

B. Adds up all the numbers from B2 to B10

COUNT tells you how many cells hold numbers. SUM is the function that adds the numbers together.

2. Column B has the numbers 4, 7, 7 and 9 in four cells. What does =COUNT(B1:B4) show?

A. 27

B. 4 ✓

There are 4 cells with numbers, so COUNT shows 4. The total of 27 is what SUM would show.

3. Which formula is written correctly to count the numbers in cells C2 to C20?

A. COUNT(C2:C20)

B. =COUNT(C2:C20) ✓

Every formula must start with an equals sign (=), or the spreadsheet just treats it as plain text.

4. Cells A1 to A5 hold 10, 20, Pizza, 30 and Cat. What does =COUNT(A1:A5) show?

A. 3 ✓

B. 5

COUNT ignores text. Only 10, 20 and 30 are numbers, so the answer is 3.

5. Cells B2 to B6 hold 5, 8, an empty cell, 2 and 9. What does =COUNT(B2:B6) show?

A. 4 ✓

B. 5

COUNT does not count empty cells. Only the four cells with numbers are counted.

Match the Pairs

=COUNT(B2:B10) → Counts how many cells from B2 to B10 contain numbers

=COUNT(C1:C20) → Counts the number cells in column C from row 1 to row 20

Count how many students gave a number score in cells D2 to D25 → =COUNT(D2:D25)

COUNT skips text, so cells with words like absent are not counted → =COUNT(A1:A5)

COUNT(B2:B10) → The formula is missing the = sign at the start, so the spreadsheet treats it as plain text. It should be =COUNT(B2:B10).

=COUNT(B2 B10) → The range needs a colon between the two cells, not a space. It should be =COUNT(B2:B10).

Key Term

=COUNT(B2:B10)

A spreadsheet formula that counts how many cells in the range B2 to B10 contain numbers. It ignores cells with text or empty cells.

Fill in the Blanks

1. =COUNT(B2:B10)

Hint: Type the function name that counts cells containing numbers.

2. Marks are in C2 to C8 =COUNT(C2:C8)

Hint: Type the range of cells that holds the marks.

3. =COUNT(B2:B10)

Hint: Type the symbol every spreadsheet formula starts with.

4. B2 = 5, B3 = cat, B4 = 8 =COUNT(B2:B4) shows 2

Hint: COUNT ignores text. Type how many cells hold numbers.

5. Survey ages are in A2 to A21 =COUNT(A2:A21)

Hint: Type the symbol that joins the first and last cell in a range.

Spot the Error

Question 1

A =COUNT(B2:B10

B =COUNT(C2:C10)

C =COUNT(D2:D10)

Line A — The closing bracket is missing. A COUNT formula must end with ), so it should be =COUNT(B2:B10).

Question 2

A B1: Age

B B2: 10

C D1: COUNT(B2:B10)

Line C — Every formula must start with =. Without it the spreadsheet treats it as plain text. It should be =COUNT(B2:B10).

Question 3

A B1: Votes

B B2: 7

C D1: =COUNT(B2-B10)

Line C — A range uses a colon, not a hyphen. B2-B10 is not a range. It should be =COUNT(B2:B10).

Question 4

A D1: =CONT(B2:B10)

B D2: =SUM(B2:B10)

C D3: =AVERAGE(B2:B10)

Line A — The function name is spelled wrong. CONT is not a spreadsheet function. It should be COUNT.

Question 5

A C1: Responses

B C2: =COUNT B2:B10

C C3: =SUM(B2:B10)

Line B — The range must be inside brackets right after the function name. It should be =COUNT(B2:B10).

Student with a class code? Join your class →