EXCEL COUNTIF

The Countif is an Excel function to count cells in a range that meets specified criteria.

Syntax:

=Countif(range,criteria)

Arguments or Parameters:

range: a range of cells or an array.
criteria: specify the condition in which cells should be counted.

Objective: Find the count of Dell in cell I13.

Step 1:

Type = sign in cell I3.
Type Countif Function

Step 2:

Select range E2:E22
Type “,”

Step 3:

Type H3 in criteria argument
Close bracket with “)”
Press Enter

Conclusion: Countif formula has given the count of Dell as 5 in the range E2:E21.