COUNT Function in Excel – count number of cells

COUNT Function in Excel returns the count of values in the cell which has only number or date values. In other words, COUNT Function count the cells only if the cells have number or date values in it.

Syntax of COUNT Function in Excel:

COUNT( value1, [value2], … )

Arguments, value1, [value2], etc. can be values or references to cell ranges.

 

Example of COUNT Function in Excel

Formula

COUNT FUNCTION IN EXCEL 1

  • The numbers and the date 03/01/2017 are counted by the count function.
  • The text value “name”, the logical value FALSE, TRUE and the error value #N/A, #VAL! are not counted by the count function.
  • The empty cells are not counted by the count function.

So only the first two rows will be taken for the count and the result will be

Result

COUNT FUNCTION IN EXCEL 2

previous COUNT Function in Excel                                                                                                                next COUNT Function in Excel