In this post, *you’ll learn about COUNTIF Function, its syntax and the way of using COUNTIF Function* in your excel spreadsheet.

## What is COUNTIF Function?

**COUNTIF Function** in excel, counts cells that meet **the single condition **in a given range of data. Arguments can be dates, numbers and text. The criteria supports logical operators(>, <, <>, =) and wildcards (*, ?) for partial matching.

#### Syntax

=COUNTIF(range, criteria)

##### Arguments:

**= –**built-in function.**COUNTIF() –**function name.**range –**the range of the given data.**criteria –**criteria that meets the given range.

Criteria can be also the value from another cell.

COUNTIF Function in excel is within a group of eight functions that splits logical criteria into two parts(range + criteria).

##### Note:

- COUNTIF Function is not a case-sensitive function. Use
**EXACT Function**for case-sensitive counting. **COUNTIF Function**only supports with**single condition**. For**Multiple conditions**use**COUNTIFS****Function.**- Cell references are not enclosed with double quotes in criteria.
- COUNTIF Function requires a range; instead you can’t use an array.
**#VALUE! Error**– when referencing other workbooks which are closed.- To manipulate values in the range argument as part of a logical test, see
**SUMPRODUCT or Filter**function.

## How to use COUNTIF Function in Excel?

*COUNTIF Function counts the cells that meet with a single condition.*

**DOUBLE QUOTES (“”):**

- Text values are must be within double quotes, but numbers are not. If the logical operator with a number, the number and operator must be within double quotes.
**Value from another cell –**value from another cell by using catenation.**WILLCARDS**:

The wildcards characters question mark (?), asterisk (*), or tilde (~) can used in criteria.The question mark (?) matches any single characters.

The asterisk (*) matches any sequences of characters.

The tilde (~) is an escape character it allows you to find the literal wildcard.

**Not equal to – **Use “<>” operator within double quotes to construct ” not equal to” criteria.

**Blank cells – **COUNTIF Function counts the cells that are blank and not blank.

**Dates – **the safest way of using dates is by **Data Function** or by referring **valid date** in another cell with cell reference.

#### Examples:

__Step 1:__

Open the workbook in your Microsoft Excel.

__Step 2:__

Enter the data, in the workbook.

__STEP 3:__

In the new cell, give the formula or the syntax. Start with ‘ =’ for every functions, COUNTIF to initiate functions name, followed by open parenthesis.

In this example, the range is sales values. Hence the values are from C3:C12.

##### STEP 4:

After calculating range, you should calculate criteria.

The criteria is with a condition >, refers to the count sales over 100.

##### STEP 5:

Press enter to get the results.

Return 5. The sales value above 100 is 5.

##### STEP 6:

Few examples;

- By using less than operator.

In this example range is from D3: D12 and the criteria are less than B1.

##### Note:

Less than operator is a text, and it is enclosed within double quotes.

Press enter to get the results.

- By using not equal to (<>) operator.

In this example, the range is D3:D12 and the criteria is not equal to.

Press enter to get the results.

Return 0. There is no match.

## Leave a Review