Mr Excel TamilExcel • PPT • Word • 500+ fx
100% Free MasterclassStatisticalBeginner Level

=COUNTIF() Interactive Masterclass & Practice Simulator

Counts the number of cells within a range that meet the given condition.

Official Syntax:=COUNTIF(range, criteria)

Live Interactive Excel Spreadsheet (Full Width)

Type directly in the cells or use the formula bar (fx)
X
Excel Live Grid: =COUNTIF() Practice Dataset
E2
fx
COUNTIF(range, criteria)

range: The range of cells you want to count.

🎯 Active Cell: Enter any formula or value into cell E2! Try =COUNTIF(B2:B6, "Shortlisted")
Sheet: Sheet 1 (Practice Table)
#AApplicant (A)BStatus (B)CScore (C)DExperience (Yrs) (D)EOutput: =COUNTIF() (E)FColumn FGColumn GHColumn H
2
3
4
5
6
7
8
9
10
Formula Assistant
Cell: E2

Excel Calculation Rules:

  • Click on any cell across the entire sheet.
  • Type =B2*C2, =COUNTIF(...), or any math!
  • Click other cells to insert cell addresses automatically.
  • Press Enter or click ✓ to evaluate live!

⚡ Pro Keyboard Shortcuts:

Enter CalculateTab Next CellF2 Edit CellEsc Cancel
Ready • Any Cell Formula Engine•Zoom: 100%
Advertisement Google AdSense Verified Slot

Google AdSense Responsive Unit (horizontal)

Compliant responsive placement adhering to Google Publisher Policies. Ads will display here upon adding your Publisher ID in .env.local.

Graded Practice Challenges (1)

Free & Unlocked
1

Exercise 1: Practice =COUNTIF() in Live Simulator

+50 XP

🎯 Target Goal:

Count the Number of "Shortlisted" Candidates

Syntax Parameters Breakdown

rangeRequired

The range of cells you want to count.

criteriaRequired

The condition that determines whether a cell is counted.

Top Pitfalls to Avoid:

  • Forgetting to close the parenthesis ) at the end of the formula.
  • Mismatching cell range sizes in lookup vectors or criteria arrays.

Corporate Pro Tips:

  • Use wildcards like "*Manager" or "?026" to match text patterns with COUNTIF.
Previous: =COUNTBLANK()View All 151+ FunctionsNext: =AVERAGE()