Quick Navigation

COUNTA Function

Excel 2007+

Summary

The COUNTA function in Excel counts all non-empty cells within a specified range or list of values. Unlike COUNT which only tallies numeric values, COUNTA includes text, logical values, errors, and formulas returning empty strings (\"\").

Syntax

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

Parameters

Parameter	Type	Required	Description
value1	`Any`	Yes	Required first argument - can be single value, cell reference, or range containing values to count
value2	`Any`	No	Optional additional arguments up to 255 total - cell references, ranges, or constants

Using the COUNTA Function

Use COUNTA when you need to determine how many cells contain any data whatsoever. Perfect for tracking data entry progress, validating form completeness, or measuring dataset population across multiple columns or sheets.

Common COUNTA Examples

Basic Range Count

=COUNTA(A2:A10)

Counts all non-empty cells in range A2 through A10, regardless of content type.

Multiple Arguments

=COUNTA(B2:B10, D2:D10, F2:F10)

Counts non-empty cells across three separate ranges simultaneously.

Mixed Data Types

=COUNTA(A1:A6)

With data: 39790, (empty), 19, 22.24, TRUE, #DIV/0! returns 5, counting numbers, text, logical, and errors.

Frequently Asked Questions

Yes, COUNTA counts formulas returning \"\" as non-empty.

COUNTA counts all non-empty cells; COUNT only counts cells with numbers.

Yes, error values like #DIV/0! are counted by COUNTA.

Common Errors and Solutions

#VALUE! error

Cause: Arguments contain invalid data types that Excel can't process

Solution: Ensure ranges contain valid cell references and arguments are appropriate

Incorrect count (too low)

Cause: Truly empty cells or formulas returning actual empty values

Solution: Verify cells contain expected data types

Notes

Maximum 255 arguments total
Processes arrays and ranges efficiently
Counts dates as numbers
Does NOT count cells with no formula or value (truly blank)

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 2024, Excel for Microsoft 365, Excel for the web

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+