fx =COUNTIF(A1:A100,"Yes")ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

COUNTIF Formula for Statistical

Count cells that meet a condition. Copy-paste ready for Excel, Google Sheets, and Airtable.

=COUNTIF(A1:A100,"Yes")
When you need this: When you need to count how many survey respondents answered "Yes" to a question (responses in A1:A100).

How it works

  1. 1Scan the range (A1:A100) cell by cell.
  2. 2Count each cell matching the criterion ("Yes").
  3. 3Return the total count.

Variations

Count numeric values above threshold
=COUNTIF(A1:A100,">50")
Count text starting with pattern
=COUNTIF(A1:A100,"Error*")

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatisticalAVERAGEIF — Average values meeting a conditionStatistical

Need a formula that's not here?

Generate custom formula →