Which function would you use to count all non-empty cells in a range?

To count all non-empty cells in a range, the COUNTA function is the appropriate choice. This function is designed to count all cells that contain data regardless of the type of data—whether it is text, numbers, or any other type of input.

COUNTA is particularly useful when working with datasets where cells may contain text or other information you want to include in the count, as opposed to only numeric data. In contrast, the COUNT function specifically counts only cells that contain numeric values, making it insufficient in scenarios where you want to also include text or other non-numeric entries.

The SUM function is used to add up all numbers in a specified range, while the AVERAGE function calculates the mean of numeric values in a range. Neither of these functions counts cells, which makes them unsuitable for the requirement of counting non-empty cells.

Therefore, when the goal is to find out how many cells contain any form of data, COUNTA is the correct function to use.