Which function is used to count the total number of cells that contain numbers in a range?

a) SUM

b) COUNT

c) AVERAGE

d) NUMBERCOUNT

Show Answer

b) COUNT

In Excel, you can use the “COUNT” function to determine the total number of cells within a specified range that contain numeric values. The COUNT function is simple to use; you provide it with the range of cells you want to count, and it returns the count of numeric values within that range. This function excludes text, empty cells, and errors, focusing specifically on numeric data. It is a valuable tool for various data analysis tasks, enabling you to quickly obtain the count of numeric entries within a range and make informed decisions based on the data.