MS Excel: CountA Function
In Excel, the CountA function counts the number of cells that are not empty as well as the number of arguments that contain values.
The syntax for the CountA function is:
CountA( argument1, argument2, ... argument_n )
argument1, argument2, ... argument_n are either ranges of cells or values. There can be up to 30 arguments.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=CountA(A1:A6) would return 5 =CountA(A1:A6, 129) would return 6 =CountA(A1:A6, 129, "techonthenet") would return 7 =CountA(A1:A6, 129, "techonthenet", -2) would return 8