Microsoft Excel COUNTA Function Help

COUNTA Function Examples

• Click to view COUNTA function examples

COUNTA Function Definition

Counts the number of occupied cells (non empty) in a range or entries in an array. COUNTA counts text, numbers, TRUE, FALSE, error values...etc. Use when you want to count everything.

COUNTA Function Syntax

=COUNTA(value1,[value2],...[Value30])

[] bracket means argument is optional which means you do not have to fill the slot.

COUNTA Function Argument Definitions

value1, value2, ...:   are 1 to 30 arguments that can contain or refer to a variety of different types of data. You can either type the information in as constants (i.e. numbers, text,...) or use cell references, ranges and names.

COUNTA Function Tips

• COUNTA is used in statistical evaluations (how many people typed in cells in a range) and to determine the number of records (rows) in a table for example.
• If you do not need to count TRUE, FALSE, text or error values, use the COUNT function to count numbers only.