Excel FunctionsLesson 80Free preview
COUNTIF
This lesson is part of Excel · All levels
Summary
COUNTIF is an Excel function that calculates the number of cells that meet a certain criterion in a range. The criteria can be numbers, text, or logical expressions such as ">100". This function is very often used to quickly analyze data.
Key points
- Calculate the cells that fit the criteria
- The text criteria are case-insensitive and support wildcards?
- The criteria in the form of text should be written in quotation marks, for example ">100"
- Use COUNTIFS if more than one criterion
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.