Counts the number of cells that contain numbers in a range or list of arguments.
Söz dizimi
COUNT(value1, [value2], …)Bağımsız değişkenler
value1zorunlu
The first item, cell reference, or range within which you want to count numbers.
value2isteğe bağlı
Additional items, cell references, or ranges up to 255.
The COUNT function is used to get the number of entries in a number field that are in a range or array of numbers. It ignores empty cells, logical values, text, or error values within the range.
=COUNT(A1:A5)→3If A1:A5 contains {10, 'apple', 20, '', 30}, the function returns 3 because it counts only the numbers.
Select the cell
Click on the cell where you want the count result to appear.
Enter the formula
Type =COUNT( followed by the range of cells you want to analyze, then close the parenthesis.
No, the COUNT function only counts cells that contain numbers.