What does the COUNTIF function do and what is its syntax?

Microsoft Excel Medium

Microsoft Excel — Medium

What does the COUNTIF function do and what is its syntax?

Key points

  • COUNTIF targets a single condition, not multiple ones
  • The function's syntax requires a range and criteria
  • It doesn't apply formatting or count unique values
  • The criteria can be a value, expression, or reference

Ready to go further?

Related questions