COUNTA function

description:

Count non-empty cells in a range.

 

syntax:

=COUNTA( value1[value2], …)

 

required arguments:

value1 The first value.

 

optional arguments:

[value2] The second value.

 

example:

The following example counts cells that are not blank (in range A1:E2).

In this range only cells A1, B2 and E2 are not blank, so the function returns 3.

 

notes:

You have to be careful because any value will be counted, even space.

 

additional examples:

 

related functions:

 

more resources:

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.