COUNT and COUNTA functions in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the COUNT function do in Excel?

The COUNT function counts how many cells contain numbers in a range. It ignores empty cells and cells with text.

beginner

What is the difference between COUNT and COUNTA functions?

COUNT counts only cells with numbers. COUNTA counts all non-empty cells, including numbers, text, and errors.

beginner

How would you count all non-empty cells in the range A1:A10?

Use the formula =COUNTA(A1:A10). It counts all cells that are not empty.

beginner

What will =COUNT(A1:A5) return if A1=5, A2="text", A3=10, A4=empty, A5=3?

It will return 3 because only A1, A3, and A5 contain numbers.

intermediate

Can the COUNTA function count cells with formulas that return empty strings ("")?

No, cells with formulas returning empty strings are considered empty by COUNTA and are not counted.

Which function counts only numeric values in a range?

A COUNT

B COUNTA

C SUM

D AVERAGE

COUNT counts only cells with numbers, ignoring text and empty cells.

What does COUNTA count in a range?

A Only numbers

B Only text

C All non-empty cells

D Only empty cells

COUNTA counts all cells that are not empty, including numbers, text, and errors.

If a cell contains a formula that returns "", will COUNTA count it?

A Only if the cell is formatted as text

B Yes, always

C Only if the formula is visible

D No, it treats it as empty

COUNTA treats cells with formulas returning empty strings as empty and does not count them.

Which formula counts how many cells in B1:B10 contain any data (numbers or text)?

A =COUNT(B1:B10)

B =COUNTA(B1:B10)

C =SUM(B1:B10)

D =COUNTBLANK(B1:B10)

COUNTA counts all non-empty cells, including text and numbers.

What will =COUNT(A1:A3) return if A1=5, A2="hello", A3=empty?

A 1

B 3

C 2

D 0

COUNT counts only numeric cells, so only A1 is counted.

Explain how COUNT and COUNTA functions differ and give an example of when to use each.

Think about counting numbers versus counting any filled cells.

Describe what happens when COUNTA is used on a range containing empty cells, text, numbers, and formulas returning empty strings.

Consider what COUNTA treats as non-empty.