Which function counts numeric cells in a range?

Which function counts numeric cells in a range?

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

Answer: (B)

Counting numeric cells in a range is done with the COUNT function. It examines each cell and increments the total only if the cell contains a number (including dates and times, since those are stored as numeric values). It does not count text, blanks, or error values. So, when you want to know how many numeric entries are in a range, COUNT is the right tool. By contrast, COUNTA counts all non-empty cells (numbers, text, dates, etc.), COUNTIF counts cells that meet a specific condition, and SUM adds up the values rather than counting how many there are.

Counting numeric cells in a range is done with the COUNT function. It examines each cell and increments the total only if the cell contains a number (including dates and times, since those are stored as numeric values). It does not count text, blanks, or error values. So, when you want to know how many numeric entries are in a range, COUNT is the right tool. By contrast, COUNTA counts all non-empty cells (numbers, text, dates, etc.), COUNTIF counts cells that meet a specific condition, and SUM adds up the values rather than counting how many there are.