​​​​Counta

The Counta function counts how many of the cells given are non-empty.

Syntax

=COUNTA(Value, ...)

Argument  Argument description
1Value Either a value or a range/array of multiple values.
2Any number of more values or ranges/arrays of multiple values. Up to 255 can be given.

Example

Here’s an example that you can try for yourself. It’ll also show the difference between Count and CountA.

Use the Counta function in cell D2 and apply it to cells A1 to A5 in the spreadsheet editor below.

Note that you can click the Show Answer button to look at the answer if you cannot figure it out.

Easy as that! You successfully used the COUNTA function, well done.

Explanation

Use =COUNTA(A1:A5) to count the number of cells that contain a value. The argument, A1:A5, is the range of cells that we count. So cells A1, A2, A3, A4, and A5. Each of these cells contains a value, therefore the result is 5.

Questions

What does Counta stand for?

It stands for Count All.

What happens with a count over empty cells, text or errors?

The count function will not count empty cells.
It will count everything else, including text and errors. It also counts empty text that could, for example, be returned by a formula.

How do I count the empty cells instead of the non-empty ones?

To count only empty cells you can use the CountBlank function.

Note that this function also counts cells that contain empty text returned by a formula. So both Counta and CountBlank count cells with empty text.

What if I want to count specific things?

Use the Count function to count only numbers.
Use the CountBlank function to count only blank cells.
Use the CountIf function to count other specific types of values.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"36c04":{"name":"Main Accent","parent":-1},"3a8fd":{"name":"Accent Light","parent":"36c04","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]},"original":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]}}]}__CONFIG_colors_palette__

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"2dd0d":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"2dd0d":{"val":"rgb(45, 164, 92)","hsl":{"h":143,"s":0.57,"l":0.41}}},"gradients":[]},"original":{"colors":{"2dd0d":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Join List
>