COUNT and COUNTA functions in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to count only numbers in the range A1:A10.

Google Sheets

= [1](A1:A10)

Drag options to blanks, or click blank then click option'

ACOUNT

BCOUNTA

CSUM

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNTA instead of COUNT counts text too.

Using SUM or AVERAGE instead of COUNT.

The COUNT function counts only numeric values in a range.

2fill in blank

medium

Complete the formula to count all non-empty cells in the range B2:B20.

Google Sheets

= [1](B2:B20)

Drag options to blanks, or click blank then click option'

ACOUNTIF

BCOUNT

CCOUNTBLANK

DCOUNTA

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which ignores text cells.

Using COUNTBLANK which counts empty cells instead.

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

3fill in blank

hard

Fix the error in the formula to count numbers in C1:C15.

Google Sheets

= COUNT([1])

Drag options to blanks, or click blank then click option'

AC1-C15

BC1.C15

CC1:C15

DC1;C15

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash or semicolon instead of colon for ranges.

Using dot which is invalid syntax.

Ranges in formulas use a colon : to specify start and end cells, like C1:C15.

4fill in blank

hard

Fill both blanks to count all non-empty cells in D1:D10 and E1:E10 separately.

Google Sheets

= [1](D1:D10) + [2](E1:E10)

Drag options to blanks, or click blank then click option'

ACOUNTA

BCOUNT

CSUM

DCOUNTBLANK

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts only numbers.

Using COUNTBLANK which counts empty cells.

Use COUNTA to count all non-empty cells in both ranges and add the results.

5fill in blank

hard

Fill all three blanks to count numbers in F1:F10, count non-empty in G1:G10, and subtract empty cells in H1:H10.

Google Sheets

= [1](F1:F10) + [2](G1:G10) - [3](H1:H10)

Drag options to blanks, or click blank then click option'

ACOUNT

BCOUNTA

CCOUNTBLANK

DSUM

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up COUNT and COUNTA.

Using SUM instead of COUNTBLANK for empty cells.

COUNT counts numbers, COUNTA counts all non-empty cells, and COUNTBLANK counts empty cells.