|Count non-empty cells in a range.|
|=COUNTA( value1, [value2], …)|
|value1||The first value.|
|[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.|
|Count cells that are not blank.|
|Remove blank rows.|
|Excel 2013 Formulas|
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.