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

The COUNTA function is used to count the number of non-empty cells in a specified range. This function is particularly useful when you want to tally cells that contain any kind of data, including numbers, text, logical values, and errors, as long as the cells are not empty.

In contrast, the COUNT function specifically counts only the cells that contain numerical values, excluding any cells with text or blanks. COUNTBLANK counts the number of empty cells, which is the opposite of what is needed in this instance. The MIN function is used to find the smallest number in a range, and it does not serve any counting purpose. Thus, when the goal is to determine the total number of non-empty cells, COUNTA is the most appropriate function to use.