The COUNT function

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

The COUNT function

Name:
Date:
Class:
A

Quick Questions

Shade in the A or B circle for each question.

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
2. Column B has the numbers 4, 7, 7 and 9 in four cells. What does =COUNT(B1:B4) show?
A 27
B 4
3. Which formula is written correctly to count the numbers in cells C2 to C20?
A COUNT(C2:C20)
B =COUNT(C2:C20)
4. Cells A1 to A5 hold 10, 20, Pizza, 30 and Cat. What does =COUNT(A1:A5) show?
A 3
B 5
5. Cells B2 to B6 hold 5, 8, an empty cell, 2 and 9. What does =COUNT(B2:B6) show?
A 4
B 5
B

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left columnRight column
1=COUNT(B2:B10) AThe range needs a colon between the two cells, not a space. It should be =COUNT(B2:B10).
2=COUNT(C1:C20) BCounts the number cells in column C from row 1 to row 20
3Count how many students gave a number score in cells D2 to D25 C=COUNT(A1:A5)
4COUNT skips text, so cells with words like absent are not counted DThe formula is missing the = sign at the start, so the spreadsheet treats it as plain text. It should be =COUNT(B2:B10).
5COUNT(B2:B10) ECounts how many cells from B2 to B10 contain numbers
6=COUNT(B2 B10) F=COUNT(D2:D25)
C

Definitions

=COUNT(B2:B10)
D

Fill in the Blanks

Complete each line of code by filling in the missing parts.

1.
=_____(B2:B10)
2.
Marks are in C2 to C8 =COUNT(_____)
3.
_COUNT(B2:B10)
4.
B2 = 5, B3 = cat, B4 = 8 =COUNT(B2:B4) shows _
5.
Survey ages are in A2 to A21 =COUNT(A2_A21)
E

Spot the Error

Shade in the letter of the line that contains an error.

Question 1
A =COUNT(B2:B10
B =COUNT(C2:C10)
C =COUNT(D2:D10)
Question 2
A B1: Age
B B2: 10
C D1: COUNT(B2:B10)
Question 3
A B1: Votes
B B2: 7
C D1: =COUNT(B2-B10)
Question 4
A D1: =CONT(B2:B10)
B D2: =SUM(B2:B10)
C D3: =AVERAGE(B2:B10)
Question 5
A C1: Responses
B C2: =COUNT B2:B10
C C3: =SUM(B2:B10)

Answer Key

The COUNT function
Section A: Quick Questions
Q1
A — Counts how many cells from B2 to B10 contain numbers
Q2
B — 4
Q3
B — =COUNT(C2:C20)
Q4
A — 3
Q5
A — 4
Section B: Match the Pairs
Q1
=COUNT(B2:B10) → Counts how many cells from B2 to B10 contain numbers
Q2
=COUNT(C1:C20) → Counts the number cells in column C from row 1 to row 20
Q3
Count how many students gave a number score in cells D2 to D25 → =COUNT(D2:D25)
Q4
COUNT skips text, so cells with words like absent are not counted → =COUNT(A1:A5)
Q5
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).
Q6
=COUNT(B2 B10) → The range needs a colon between the two cells, not a space. It should be =COUNT(B2:B10).
Section C: Definitions
Q1
=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.
Section D: Fill in the Blanks
Q1
=COUNT(B2:B10)
Q2
Marks are in C2 to C8 =COUNT(C2:C8)
Q3
=COUNT(B2:B10)
Q4
B2 = 5, B3 = cat, B4 = 8 =COUNT(B2:B4) shows 2
Q5
Survey ages are in A2 to A21 =COUNT(A2:A21)
Section E: Spot the Error
Q1
A — The closing bracket is missing. A COUNT formula must end with ), so it should be =COUNT(B2:B10).
Q2
C — Every formula must start with =. Without it the spreadsheet treats it as plain text. It should be =COUNT(B2:B10).
Q3
C — A range uses a colon, not a hyphen. B2-B10 is not a range. It should be =COUNT(B2:B10).
Q4
A — The function name is spelled wrong. CONT is not a spreadsheet function. It should be COUNT.
Q5
B — The range must be inside brackets right after the function name. It should be =COUNT(B2:B10).