How to Use COUNTIF in Google Sheets
COUNTIF is a powerful function that counts the number of cells in a range that meet a specific condition. It is essential for data analysis in Google Sheets.
Understand the COUNTIF Syntax
COUNTIF(range, criterion). The range is the group of cells to evaluate, and the criterion is the condition that determines which cells to count.
Count Cells with Exact Text Match
Use =COUNTIF(A1:A100, "Complete") to count how many cells in the range contain the word "Complete".
Count Cells with Numeric Conditions
Use =COUNTIF(B1:B100, ">50") to count cells with values greater than 50. You can use >, <, >=, <=, and <> operators.
Count Cells with Partial Text Match
Use =COUNTIF(C1:C100, "*urgent*") to count cells containing "urgent" anywhere in the text. The asterisks are wildcards.
Use COUNTIF with Cell References
Use =COUNTIF(D1:D100, E1) instead of hardcoding the criterion. This makes your formulas dynamic and easier to update.
💡 Cell references update automatically when copied to other cells.
Try These Templates
Frequently Asked Questions
Can COUNTIF use multiple conditions?
For multiple conditions, use COUNTIFS(range1, criterion1, range2, criterion2).
Is COUNTIF case-sensitive?
No. COUNTIF is not case-sensitive. "Apple", "apple", and "APPLE" are all counted as matches.