How to Use Excel COUNT Function (Examples + Video)

Excel COUNT Function (Example + Video)

Excel COUNT Function

When to use Excel COUNT Function

COUNT function can be used to count the number of cells that contain numbers.

What it Returns

It returns a number that represents the number of cells that contain numbers.

Syntax

=COUNT(value1, [value2], …)

Input Arguments

  • value1 – the first item, cell reference, or range within which you want to count numbers.
  • [value2], … – (optional) up to 255 additional items, cell references, or ranges within which you want to count numbers.

Additional Notes

  • Numerical values are counted.
  • Dates and text representation of numbers (such as 1 in double quotes – “1”) are counted.
  • Logical Values (TRUE/FALSE) typed directly into the formula are counted.
    • However, cell reference that refers to cells that contain logical values are ignored
  • Arguments that are error values or text that cannot be translated into numbers are not counted.
  • If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are not counted.

Excel COUNT Function – Live Example

Excel COUNT Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster