Excel > Functions
COUNTA Function
The COUNTA function counts the number of non empty cells in a given range. COUNTA will count cells containing values, labels and formulas.
The syntax for the COUNTA function is:
=COUNTA(value1,value2,...)
Argument |
Purpose |
|---|---|
Value1,value2,... |
the range of cells you want to count. The function can take up to 30 different cell ranges |
The example below demonstrates the COUNTA function being used to count a range of cells.
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
