The COUNTIF function is used to count cells that meet a criterion; for example, to count, how many numbers of times, sale made to a particular customer.
The COUNTIF function, categorized as a Statistical Function, can be used to counts cells with dates, text, and, numbers to match a criterion. For partial matching, it supports logical operator, such as (>,<,<>,=) and wildcards (*,?).
=COUNTIF (range, criteria) where,
range – The range of cells that you want to count.
criteria – The criterion, which specifies what to count; e.g. count cells if greater than etc.
1. Type, =COUNTIF, select range, and criteria.