The function of the COUNT function is to count cells that contain numeric data, the COUNTA function in Microsoft Excel is used to count non-empty cells in a certain area. The following article will introduce the syntax and usage of the COUNTA function.
The COUNTA function counts the number of nonblank cells in a range.
Syntax: COUNTA(value1, [value2], …)
Note: Value1 is a required argument, is the data range to be counted. Value2 and Value3 are options because they are enclosed in , not required.
- The COUNTA function counts cells that contain any type of information, including error values and blank text (“”). For example, if the range contains a formula that returns an empty string, the COUNTA function will count that value. The COUNTA function does not count blank cells.
- If you don’t need to count logical values, text, or error values (in other words, if you just want to count cells that contain numbers), use the COUNT function.
Example: Counts nonblank cells in the following data table
You can see Excel highlights those cell ranges and when you press Enter, the result appears: