asked 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?

asked
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.
answered
User Nicke Manarin
by
7.7k points
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.