Which function counts numeric cells?

Which function counts numeric cells?

• A. SUM
• B. COUNTA
• C. COUNTIF
• D. COUNT

Answer: (D)

COUNT is used to tally only numeric entries in a range. In spreadsheets, numbers (including dates and times stored as numeric values) are counted, while blanks and text are ignored. This makes it the right choice when the goal is to know how many cells contain numeric data, not just how many cells are non-empty. If you used COUNTA, you'd count text as well, which isn’t what you want here; COUNTIF adds a condition to count only certain cells; SUM would add the numbers instead of counting them.

COUNT is used to tally only numeric entries in a range. In spreadsheets, numbers (including dates and times stored as numeric values) are counted, while blanks and text are ignored. This makes it the right choice when the goal is to know how many cells contain numeric data, not just how many cells are non-empty. If you used COUNTA, you'd count text as well, which isn’t what you want here; COUNTIF adds a condition to count only certain cells; SUM would add the numbers instead of counting them.