how to use excel count function

Use Excel COUNT Function to count cells which have numbers in it. In simple words, count function will only return the count of cells which have numbers & it will 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 on Excel COUNT Function

  • You can specify up to 255 arguments.
  • It can count numbers, dates & 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 & error values will be ignored by count function.
  • If you specify a reference or an array, count function will only return the number of cells which have a numeric value.
  • Empty cells will also ignore by count function.

Examples

In the below example, I have used count 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.

Count Number With Excel COUNT Function

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

Insert Logical Value In Cell With Excel Count Function

Count Function has recognized both of the values and returned 2 in the result.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel COUNT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have COUNTA function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.