In Excel, which function counts the number of numeric entries in a range?

In Excel, which function counts the number of numeric entries in a range?

• A. COUNT
• B. SUM
• C. AVERAGE
• D. MAX

Answer: (A)

This function tallies how many cells in a range contain numeric data. It checks each cell and increments the count only when the cell's value is a number, so it ignores text and blank cells. Dates are stored as numbers, so they’re counted too. It won’t count booleans or error values as numbers, which is why it’s the right choice when you need a true count of numeric entries rather than a sum, average, or maximum. For context, summing would add values, averaging would compute a mean, and taking the maximum would return the largest value, none of which return a simple count of numbers. For example, in a range with 5, some text, 7, and a blank cell, you’d get a count of 2.

This function tallies how many cells in a range contain numeric data. It checks each cell and increments the count only when the cell's value is a number, so it ignores text and blank cells. Dates are stored as numbers, so they’re counted too. It won’t count booleans or error values as numbers, which is why it’s the right choice when you need a true count of numeric entries rather than a sum, average, or maximum. For context, summing would add values, averaging would compute a mean, and taking the maximum would return the largest value, none of which return a simple count of numbers. For example, in a range with 5, some text, 7, and a blank cell, you’d get a count of 2.