Returns the count of numbers.

Syntax

= COUNT(value1, [value2], …)

Arguments

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

Notes

  • It can count numbers, dates, and text which represent numbers.
  • If you enter a logical value or a 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, it will only return the number of cells that have a numeric value.

Related


Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac