What is the function of count function in excel?

The function of the count function in excel is to count the number of numbers and count the number of data in a given data set or cell range. The COUNT function is used to count the number of values ​​in the listed parameters, which is a function that implements the counting function.

The COUNT function is used in Excel to count the number of data in a given data set or cell range. The COUNT function can only count numeric data, and empty cells, logical values, or text data will be ignored. Therefore, you can use this function to determine whether a given cell range contains empty cells.

Syntax:

COUNT(value1,value2, ...)

value1 is a required parameter. The first item, cell reference, or range in which the number of numbers is to be counted.

value2, ... are optional parameters. You can have up to 255 other items, cell references, or ranges in which you want to count numbers.

Note:

The function COUNT will count numerical numbers when counting; however, error values, null values, logical values, and literals will be ignored.

If the parameter is an array or reference, only the numbers in the array or reference will be counted; empty cells, logical values, text or error values ​​in the array or reference will be ignored. Specifically:

• If the argument is a number, date, or text representing a number (for example, a number enclosed in quotes, such as "1"), it will be counted.

• Logical values ​​and text representing numbers typed directly into the argument list are counted.

• If the argument is an incorrect value or text that cannot be converted to a number, it will not be counted.

• If the parameter is an array or reference, only the number of numbers in the array or reference is counted. Empty cells, logical values, text, or error values ​​in arrays or references are not counted.

• To count the number of logical, text, or error values, use the COUNTA function.

• To count only the number of numbers that meet a certain condition, use the COUNTIF function or COUNTIFS function.

Example 1: Calculate how many numbers there are in cells B1 and D1 (excluding cell C1)

COUNT(B1,D1)

Example 2 : Calculate the number of numbers from cell B1 to cell D1 (including cell C1)

COUNT(B1:D1)

Example 3:

COUNT("B1","D1","123","hello")

The result is

1

because only "123" is a number. Because B1 and D1 are enclosed in quotation marks, they are characters, not numbers.

Related learning recommendations: excel basic tutorial

The above is the detailed content of What is the function of count function in excel?. For more information, please follow other related articles on the PHP Chinese website!