ADVERTISEMENT
How to use COUNTIF Function in Excel | COUNTIF Formula | Using COUNTIF | Excel Tutorial
Note: If video does not play,
just refresh page and then Play video or Just Click on this text.
Description
The COUNTIF function is a pre-defined function in Excel, counts cells in a range that meet a single condition. You can use COUNTIF to count cells containing dates, numbers, and text. Conditions used in COUNTIF support logical operators (>, <, <>, =) and partial match wildcards (*, ?).
Syntax
The syntax for COUNTIF looks like this:
=COUNTIF(range,criteria)
Range = The range/array of cells to count.
Criteria = Criteria that control which cells are counted.
The pictures below shows examples of the syntax needed for common criteria:
Example 01: Count by Word or specific text.
Example 02: Count the values which are >300
Example 03: Count the values which are <200
