Which Excel function counts non-empty cells in a range?

The function that counts non-empty cells in a range is COUNTA. This function is specifically designed to evaluate each cell in the specified range and count it if it contains any type of data—whether that be text, numbers, logical values, or even error values. This makes COUNTA particularly useful when you need to determine how many cells hold data as opposed to just counting numeric entries or specific types of data.

In contrast, the COUNT function only counts cells that contain numerical values, making it less versatile for this purpose. The SUM function is focused on adding together numeric values in a specified range and does not count cells at all. Lastly, there is no function called TOTAL in Excel, which means that option is not valid. Thus, COUNTA is the appropriate choice for counting all non-empty cells, regardless of the type of data they contain.