How to use Count Function in Excel

How to use Count Function in Excel2018-11-16T09:59:18+00:00

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], …)

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


More Information

  1. You can specify up to 255 arguments.
  2. It can count numbers, dates and text which represent numbers.
  3. If you enter a logical value or text representation of a number directly into the function it will count them.
  4. Text and ERROR values will be ignored.
  5. 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.

Count Number With Excel COUNT Function

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.

Insert Logical Value In Cell With Excel Count Function

What's Next

Related Functions

Related Tips