205k views
0 votes
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

User Rita Han
by
8.2k points

1 Answer

3 votes
The Excel function in question is COUNT. The COUNT function counts the number of cells in a specific range, that contain numbers. The range of values can be numbers, text or cell references, but the COUNT function will only count the numbers. To count logical values you can use the function COUNTA.
User Nicke Manarin
by
7.7k points