How to count non-empty cells in Excel 2013 - COUNTA

The COUNTA function is used to count cells that are not empty.

Syntax:
=COUNTA(value1, value2, …value30)

Arguments:
value1: These can be cell references or can be directly entered. A continuous range of cells can be given as single argument.

Follow the below steps to count cells that are not empty:

1. Enter the data in the worksheet

2. Select any cell where you want to get the count of cells

3. Enter a COUNTA formula and select the required cell range as argument

4. Press the Enter key.

This will give the count of the cells that contain non-empty cells

Note: The COUNTA function also count cells with formulas (even if they were value pasted later) and spaces

For example, formula like =IF(A1="","", "na") may have inherent "" value to signify empty cell and it may appear to be blank, but COUNTA fuction will include this in its count.

Add-on:
To check if the cell contains any character (which looks empty), you can use =LEN(cell) function. This should ideally give 0 if the cell is empty.

However, the "" (often after value pasting the formula) does not get detected, to see this we need to check mark "Transition navigation keys"

File >>> Options >>> Advanced >>> Lotus Compatibility