COUNTIF and COUNTIFS in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the COUNTIF function do in Google Sheets?

COUNTIF counts the number of cells in a range that meet a single condition you specify. For example, it can count how many times a word or number appears.

beginner

How is COUNTIFS different from COUNTIF?

COUNTIFS counts cells that meet multiple conditions at the same time. It lets you check more than one rule, like counting cells that are greater than 10 and less than 20.

beginner

Write the formula to count cells in range A1:A10 that equal "Apple".

The formula is =COUNTIF(A1:A10, "Apple"). It counts how many cells exactly say "Apple".

intermediate

Write a COUNTIFS formula to count cells where A1:A10 are "Apple" and B1:B10 are greater than 5.

Use =COUNTIFS(A1:A10, "Apple", B1:B10, ">5"). It counts rows where both conditions are true.

beginner

Can COUNTIF and COUNTIFS work with text and numbers?

Yes! Both functions can count cells with text or numbers. You just write the condition accordingly, like "Apple" for text or ">10" for numbers.

What does the formula =COUNTIF(B2:B10, ">=50") do?

A Counts cells in B2:B10 with values 50 or more

B Counts cells in B2:B10 with values less than 50

C Counts all cells in B2:B10

D Counts cells with text "50"

The formula counts cells with numbers greater than or equal to 50.

Which function counts cells based on multiple conditions?

A COUNTIF

B COUNTIFS

C SUM

D AVERAGE

COUNTIFS lets you count cells that meet several conditions at once.

How would you count cells in A1:A20 that exactly say "Banana"?

A =COUNTIF(A1:A20, "Banana")

B =COUNTIF(A1:A20, ">Banana")

C =COUNTIFS(A1:A20, "Banana")

D =COUNT(A1:A20, "Banana")

COUNTIF with the exact text "Banana" counts matching cells.

What will =COUNTIFS(A1:A5, ">10", B1:B5, "<5") count?

A Cells in A1:A5 less than 5 and B1:B5 greater than 10

B All cells greater than 10 or less than 5

C Cells in A1:A5 greater than 10 and B1:B5 less than 5 in the same row

D Cells in A1:A5 or B1:B5 that meet either condition

COUNTIFS counts rows where both conditions are true together.

Can COUNTIF count cells with partial text matches using wildcards?

A Wildcards are not supported in Google Sheets

B No, it only counts exact matches

C Only COUNTIFS can use wildcards

D Yes, using * and ? as wildcards

COUNTIF supports wildcards like * (any characters) and ? (single character).

Explain how to use COUNTIF to count cells with a specific number or text.

Think about counting how many times a word or number appears in a list.

Describe a situation where COUNTIFS is more useful than COUNTIF.

Think about filtering data with more than one rule.