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

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 ("").