COUNT and COUNTA functions in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the COUNT function do in Google Sheets?

The COUNT function counts how many cells in a range contain numbers. 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, logical values, and errors.

beginner

Write a formula to count all non-empty cells in the range A1:A10.

Use =COUNTA(A1:A10) to count all cells that are not empty in the range A1 to A10.

beginner

If a range contains numbers, text, and empty cells, which function counts only the numbers?

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

intermediate

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

Yes, COUNTA counts cells with formulas even if they return empty strings (""), because the cell is not truly empty.

Which function counts only numeric values in a range?

A COUNT

B COUNTA

C SUM

D AVERAGE

COUNT counts only numeric values, ignoring text and empty cells.

What will =COUNTA(A1:A5) return if A1=5, A2="Hello", A3=empty, A4=TRUE, A5="" (empty string)?

A 3

B 4

C 5

D 2

COUNTA counts all non-empty cells including text, numbers, TRUE, and empty strings returned by formulas.

If you want to count all cells that are not empty, which function should you use?

A COUNTA

B COUNT

C COUNTBLANK

D SUM

COUNTA counts all non-empty cells regardless of content type.

What does the COUNT function ignore?

A Numbers

B Dates

C Text and empty cells

D Logical values

COUNT ignores text and empty cells; it counts only numbers.

Which function would count cells with formulas that return empty strings as non-empty?

A COUNT

B ISBLANK

C COUNTBLANK

D COUNTA

COUNTA counts cells with formulas returning empty strings because they are not truly empty.

Explain how COUNT and COUNTA functions differ in counting cells in a spreadsheet.

Think about what types of cell contents each function counts.

Describe a real-life example where you would use COUNTA instead of COUNT.

Consider when you want to count any filled cell, not just numbers.