fx
FunctionPedia
Quick Answer

COUNTA Function

COUNTA returns the count of all non-empty cells in a range, including text, numbers, and logical values.

✓ Excel✓ Google SheetsExcel All versions

Syntax

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

Parameters

ParameterDescriptionRequired
value1The first item, cell reference, or range to count.Required
value2Optional additional items, cell references, or ranges to count.Optional

Basic Example

Count all non-empty cells in a range

=COUNTA(A1:A10)
Result8

Counts all cells in A1:A10 that contain any value (text, numbers, or logical values), ignoring only completely blank cells.

Advanced Examples

Example 1: Count responses in a survey

Survey analysis

Count how many respondents answered a question

=COUNTA(B2:B100)
Result: 95
Counts all non-empty cells in the response column to find the number of completed surveys.

How COUNTA Works

COUNTA examines each cell in the range and counts it if it contains any value — numbers, text, logical values (TRUE/FALSE), or error values. Only completely blank cells are excluded.

1
Select output cell
Choose where the result should appear.
2
Enter formula
Type =COUNTA(range) where range contains your data.
3
Press Enter
The result shows the total count of non-empty cells.

Important Notes & Limitations

  • COUNTA counts cells with formulas that return empty strings ("") as non-empty.

  • For counting only numeric values, use COUNT instead.

Common Errors & Fixes

0All cells in the range are blank

Fix: Verify your data range is correct.

Download Practice File

Practice COUNTA with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the COUNTA function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Tutorials

Convert Text to Number in Excel and Google Sheets

Convert text to number in Excel and Google Sheets with VALUE, multiplication and Paste Special. Handles currency symbols, hidden spaces and #VALUE! errors.

COUNTIF with Wildcard: Count Cells by Text Pattern

COUNTIF with wildcard patterns counts cells by prefix, suffix or length. Learn the * and ? rules, how to escape a literal asterisk, and where numbers fail.

Excel Sales Dashboard: Build One That Updates Itself

Build an Excel sales dashboard that keeps itself current: one flat sales table, SUMIFS KPIs, XLOOKUP targets and FILTER drill-downs that grow with the data.

Frequently Asked Questions

What counts as non-empty for COUNTA?
Text, numbers, dates, logical values (TRUE/FALSE), and error values all count. Only completely blank cells are ignored.
Does COUNTA count cells with formulas?
Yes, including cells with formulas that return empty strings ("").