Exceljet

Quick, clean, and to the point

Excel COUNTA Function

Excel COUNTA function
Summary 

The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.

Purpose 
Count the number of non-blank cells
Return value 
A number representing non-blank cells.
Syntax 
=COUNTA (value1, [value2], ...)
Arguments 
  • value1 - An item, cell reference, or range.
  • value2 - [optional] An item, cell reference, or range.
Usage notes 

The COUNTA function counts cells that contain numbers, text, logical values, error values, and empty text returned in formulas (""). COUNTA does not count cells that are completely empty. For example, to count non-empty cells in the range A1:A10:

=COUNTA(A1:A10)

Invisible characters

Be aware that COUNTA will also count cells that look empty, but actually contain invisible characters or an empty string ("") returned by a formula. You can check which cells are blank using Go To > Special > Blanks:

  1. Select a range
  2. Open Go To dialog (Control + G)
  3. Press "Special"
  4. Select "Blanks"

Notes

  • COUNTA function to count cells that contain numbers, text, logical values, error values, and empty text ("").
  • COUNTA will also count hard-coded values. For example, =COUNTA("a",1,2,3,"") returns 5.
  • To count numeric values only, use the COUNT function.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.