What is the function of count function

What is the function of count function?

COUNT function is used in Excel to count the number of data in a given data set or cell range. Its syntax structure is COUNT(value1, value2, ...). 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.

Recommended: "Excel Tutorial"

Syntax

EXCEL： 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.

Explanation

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. The details are as follows:

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

Logical values ​​and text representing numbers typed directly into the parameter 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 match a certain condition, use the COUNTIF function or COUNTIFS function.

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