|Connect us with


Countif function

Syntax | Count function | Countif function | Countif on Text | Counta function | Countblank function

In this tutorial we are going to discuss COUNT function in Excel and COUNTIF function in Excel, COUNTA function and COUNTBLANK function in Excel with detailed explanation and examples.

Syntax:

Count Syntax: =COUNT(value1, value2, ...).

Countif Syntax: =COUNTIF(range, criteria).

Counta Syntax: =COUNTA(value1, value2, ...).

Countblank Syntax: =COUNTBLANK(range).

COUNT function in Excel

COUNT function in Excel is used find the count of the numbers in particular cells or range.

In the following example, we have list of numbers in "A" column. to count the number of cells that contain numbers in this range, we can use COUNT function in Excel.

Count Function In Excel

To get the result execute the below steps,

1. Put the cursor where you want to find the count of the numbers. in this example cell A10.

2. Enter a COUNT formula in cell A10,=COUNT(A2:A9).

3. Press the Enter key to complete the formula.

4. The result will be 7, because the range A2:A9 contians only 7 numbers. cell A9 is not counted, because it not contains number.

Result

Count Function Example

Note: The COUNT function counts cells that contain dates. because dates are stored as a numbers in Excel.

Count Function Date Example

COUNTIF function in Excel

Countif function in Excel is used to find the count of the repeated values in particular cells or range. in other words, countif counts the number of cells that meet the criteria you specify. we have already discuseed IF function on logical conditions.

COUNTIF Function In Excel

In the above example, we have list of number in "A" column. to counts the number of cells that equal to the number 4. we can use COUNTIF function in Excel.

To get the result execute the below steps,

1. Put the cursor where you want to find the count of the numbers. in this example the cell is A10.

2. Enter a COUNTIF formula in cell A10,=COUNTIF(A2:A9,4)).

3. Press the Enter key to complete the formula.

4. The result will be 2 . because in the range A2:A9 the number 4 has been repeated 2 times.

Result

COUNTIF Function Example

COUNTIF function on Texts

Use the COUNTIF function in Excel to count the cells that contain specific text.

In the following example, we have a list of texts in the range A14:A22. and to count the cells that contains specific text in this range, we have used COUNTIF function=COUNTIF(A14:A22,"Karnataka").

COUNTIF Function on Texts

it means in the above example the text Karnataka repeated 3 times. in this way we can use COUNTIF function to count the repeated text in the range.

Note: Always use the double quotes while using texts in formula or function in Excel.

COUNTA function in Excel

The COUNTA function in Excel counts cells containing any type of information, including numbers, error values, and empty text except blank cells.

COUNTIA Function In Excel

In the above example, the COUNTA function counts all the cell types of information in the range A28:A36. except for blank values.

COUNTBLANK function in Excel

The COUNTBLANK function in Excel counts cells containing blank values. it means it counts empty cells in the given range.

COUNTBLANK Function In Excel

In the above example, the COUNTBLANK function counts all the cells which contain empty values in the range A41:A49.

You May Also Like the Following Excel Tutorials:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments




Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.