Tutorial Excel Countif

The countif function below counts the number of cells that are equal to 20.

Tutorial excel countif. Countif where do you want to look what do you want to look for. Excel countif function is used for counting cells within a specified range that meet a certain criterion or condition. Use the countif function in excel to count cells that are equal to a value count cells that are greater than or equal to a value etc. The tutorial explains how to use countifs and countif formulas with multiple criteria in excel based on and as well as or logic.

Countif is in a group of eight functions in excel that split logical criteria into two parts range criteria. This tutorial demonstrates how to use excel countif to count cells based on one or more criteria. Countif only supports a single condition. In plain english countif function can be described as a formula that can be used for counting the number of cells that fulfill a particular condition within a predefined range.

In its simplest form countif says. For example you can write a countif formula to find out how many cells in your worksheet contain a number greater than or less than the number you specify. Use countif one of the statistical functions to count the number of cells that meet a criterion. As a result the syntax used to construct criteria is different and countif requires a cell range you cant use an array.

As the name suggests excel countif function is a combination of count and if formula. Countif function counts the number of times within the specified range of cells that perform the specified value as a criterion. You will find a number of examples for different data types numbers dates text wildcard characters non blank cells and more. If you need to apply multiple criteria use the countifs function.