« Previous Next »

Count Function

The COUNT function in Microsoft Excel is used to count the number of cells that contain numerical data within a specified range. It only counts cells with numbers, so any cells containing text, blank cells, or errors will not be included in the count. This function is useful when you want to determine how many numbers are present in a set of data.

Syntax

=COUNT(value1, [value2], ...)

value1: This is required and can be a range of cells, a single cell, or a constant you want to count.

value2, ...: These are optional additional values that you can include. You can add up to 255 additional items.


Example

Suppose you have data in cells A1 to A10, and you want to count how many cells contain numbers:

=COUNT(A1:A10)

This formula will return the number of cells in that range that contain numbers.


Related Functions
  • COUNTA: Use this function to count all non-empty cells, including text, numbers, and other data types.
    =COUNTA(A1:A10)

  • COUNTIF: This function counts the number of cells that meet a specified condition.
    =COUNTIF(A1:A10, ">100") – Counts cells in the range A1:A10 that contain values greater than 100.

  • COUNTIFS: This function allows you to apply multiple conditions to determine which cells to count.
    =COUNTIFS(A1:A10, ">100", B1:B10, "Region1") – Counts cells in A1:A10 greater than 100 where the corresponding cells in B1:B10 equal "Region1".

Additional Notes
  • The COUNT function will not count text, logical values (TRUE/FALSE), or empty cells.
  • To count all non-empty cells (including text), use COUNTA instead.
  • To count based on specific criteria, use the COUNTIF or COUNTIFS functions.