COUNTA function


Count non-empty cells in a range.



=COUNTA( value1[value2], …)


required arguments:

value1 The first value.


optional arguments:

[value2] The second value.



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.



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.