Which function counts cells containing numbers?

Spreadsheet software provides various functions to analyze and summarize data within a range of cells. One common analytical task is to determine how many cells within a specified range contain numerical values, which is distinct from summing the values or counting all non-empty cells.

• A: COUNT is the correct function. The COUNT function specifically counts the number of cells in a range that contain only numerical values. It ignores empty cells, text, logical values (TRUE/FALSE), and error values.
• B: COUNTA is incorrect because it counts all non-empty cells, including those with text, numbers, logical values, and error values.
• C: COUNTBLANK is incorrect as it counts the number of empty cells within a specified range.
• D: SUM is incorrect because it calculates the total sum of numbers in a range, rather than counting the cells that contain numbers.