******Excel COUNT Function** to count cells which have numbers. In simple words, it will only return the count of cells which have numbers and ignore all the other cell.

## Syntax

COUNT(value1, [value2], …)

- value1 A cell reference, an array or a number which is directly entered into the function.
- [value2] A cell reference, an array or a number which is directly entered into the function.

## More Information

- You can specify up to 255 arguments.
- It can count numbers, dates and text which represent numbers.
- If you enter a logical value or text representation of a number directly into the function it will count them.
- Text and ERROR values will be ignored.
- If you specify a reference or an array, count function will only return the number of cells which have a numeric value.

## Examples

In the below example, we have used this function to count cells from the range A1:A10 and it has return 8 in the result.

In cell A3, we have a logical value and in cell A7 we have a text. Count function has ignored both of the cells.

But, if you enter a logical value directly into the function it will count it. In the below example, we have inserted a logical value and a number using double quotation marks.

## What's Next

**Related Functions**

- COUNTA Function: It counts all the cells which are not empty. It doesn't matter which type of value is there in a cell, it counts all the cell with values in it.
- COUNTBLANK Function: It counts all the cells which are empty/blank, but if a cell has a blank space it will not count it.
- COUNTIF Function: It counts the number of cells which meet a criterion. You need to specify a criterion and a range of cell to check that criterion.
- COUNTIFS Function: It counts the number of cells which meet criteria. You need to specify criteria and ranges to check those criteria.

**Related Tips**

- Count Cells with Text: In Excel, we have different formulas which we can use to count all the cells where we have text values. But the point is [...]
- Count Words in Excel: When it comes to Excel there is no such option to count words. But [...]
- Count Unique Values: In Excel, you can use different methods to get a count of unique values. It depends that which type of values you have so that [...]
- COUNTIF OR: Normally, when we COUNTIF we can just count cells by specifying a single condition and with COUNIFS we can specify

This function is the part of the list of Top 100 Excel functions [with Examples] and from here you can also learn some Amazing Formula Tips.