COUNTIF and COUNTIFS in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to count how many cells in range A1:A10 contain the number 5.

Google Sheets

=COUNTIF(A1:A10, [1])

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

A"5"

B"=5"

C5

D>=5

Attempts:

3 left

💡 Hint

Common Mistakes

Using >=5 counts all numbers greater or equal, not just 5.

To count cells equal to 5, you can use the number 5 without quotes.

2fill in blank

medium

Complete the formula to count cells in B1:B20 that contain text starting with "apple".

Google Sheets

=COUNTIF(B1:B20, [1])

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

A"apple*"

B"*apple*"

C"*apple"

D"apple"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "apple" counts only cells exactly equal to "apple".

Using "*apple" counts cells ending with "apple", not starting.

To count cells starting with "apple", use the wildcard * after the word: "apple*".

3fill in blank

hard

Fix the error in the formula to count cells in C1:C15 that are greater than 10.

Google Sheets

=COUNTIF(C1:C15, [1])

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

A10

B>10

C>=10

D">10"

Attempts:

3 left

💡 Hint

Common Mistakes

Writing >10 without quotes causes a formula error.

Using 10 counts cells equal to 10, not greater.

The criteria must be a text string, so use ">10" with quotes.

4fill in blank

hard

Fill both blanks to count cells where A1:A10 are "Yes" and B1:B10 are greater than 50.

Google Sheets

=COUNTIFS(A1:A10, [1], B1:B10, [2])

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

A"Yes"

B>50

C">50"

D"No"

Attempts:

3 left

💡 Hint

Common Mistakes

Using >50 without quotes causes an error.

Using Yes without quotes causes an error.

COUNTIFS needs criteria as text strings. Use "Yes" and ">50" in quotes.

5fill in blank

hard

Fill all three blanks to count cells where D1:D20 start with "A", E1:E20 equal 100, and F1:F20 are less than 50.

Google Sheets

=COUNTIFS(D1:D20, [1], E1:E20, [2], F1:F20, [3])

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

A"A*"

B100

C"<50"

D"=100"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using wildcards for text matching.

Use "A*" to match text starting with A, "=100" for exact number 100, and "<50" for less than 50, all as text strings.