Which function would you use to count only numeric entries in a selected range?
2023
Which function would you use to count only numeric entries in a selected range?
- A.
COUNTA
- B.
COUNTIF
- C.
COUNTBLANK
- D.
COUNT
Attempted by 60 students.
Show answer & explanation
Correct answer: D
The correct answer is Option D: COUNT. In spreadsheet applications like Excel or Google Sheets, the COUNT function is specifically designed to count only the cells that contain numeric values within a specified range, completely ignoring text, errors, or empty cells.