Excel COUNTIF Function: Criteria-Based Cell Counting

What is the COUNTIF Formula?

The COUNTIF function counts cells that meet a single criterion.

When to Use the COUNTIF Formula

The COUNTIF function can be used to count cells with dates, numbers, and text that match specific criteria.

COUNTIF Logical Operators and Wildcards

The COUNTIF function supports logical operators (>, <, <>, =) and wildcards (*, ?, "") for partial matching.

Principal Purpose of COUNTIF

To count cells that match specified criteria.

COUNTIF Return Value

A number representing the count of cells.

How the COUNTIF Formula Works

COUNTIF counts the number of cells in the specified range that contain numeric values less than a given 'X' and returns the result as a number.

Complete the Statements: COUNTIF Syntax & Arguments

• Syntax: =COUNTIF(range, criteria)
• Arguments: range - The range of cells to count.
• Arguments: criteria - The criteria that controls which cells should be counted.
• The COUNTIF function in Excel counts the number of cells in a range that match the supplied criteria.
• Non-numeric criteria needs to be enclosed in double quotes, but numeric criteria does not.

COUNTIF Formula Examples

• =COUNTIF(A1:A10, 100) // Counts cells equal to 100
• =COUNTIF(A1:A10, ">32") // Counts cells greater than 32
• =COUNTIF(A1:A10, "jim") // Counts cells equal to "jim"
• =COUNTIF(A1:A10, "<"&B1) // Counts cells less than the value in B1

True or False: COUNTIF Statements

• a) Range - The range of cells to count. (T)
• b) Criteria - The criteria that controls which cells should not be counted. (F)
• c) COUNTIF is a function to count cells that meet a single criterion. (T)
• d) The COUNTIF function does not support logical operators (>, <, <>, =) and wildcards (*, ?) for partial matching. (F)

Match the COUNTIF Concepts

• 1. Syntax: =COUNTIF(range, criteria)
• 2. Arguments: range and criteria
• 3. Purpose: Counts cells that match criteria