COUNT
Formulas / COUNTTo count numerical values.
=COUNT(value1, [value2], ...)
- value1 - an item, cell, reference, or range
- value2, ... - [OPTIONAL] items, cell references, or ranges. Up to 255 total arguments accepted.
Examples
=COUNT(1,2,3) // returns 3The COUNT function returns the number of values in a given range. In this example, the range is 1,2,3 and the function returns 3 because there are three values in the range.
=COUNT(1,"a","b") // returns 1The COUNT function returns the number of values in a given range. In this example, the range is 1,"a","b" and the function returns 1 because there is only one numeric value in the range.
=COUNT("apple",100,125,100,"orange") // returns 3The COUNT function returns the number of values in a given range. In this example, the range is "apple",100,125,100,"orange" and the function returns 3 because there are three numeric values in the range.
=COUNT(A1:A10) // returns the count of the numbers in A1:A10The COUNT function returns the number of values in a given range. In this example, the range is A1:A10.
Summary
The COUNT function is a versatile function that can be used to count the number of cells or arrays of numbers.
- The COUNT function returns the count of numerical values in the arguments of the function
- COUNT takes multiple arguments in the form value1, value2, value3, etc.
- The arguments can be hardcoded values, cell references, or ranges. Up to 255 arguments may be provided.
- COUNT counts all types of numbers, including negative numbers, percentages, dates, times, fractions, and formulas returning numbers.
- COUNT ignores empty cells and text values, as well as logical values (TRUE and FALSE).
- Dates and times are numbers, so they are included in COUNT.
Frequently Asked Questions
What is the count function?
How does the COUNT function work?
What does the COUNT function return?
Where can I use the COUNT function?
What's the difference between COUNT and COUNTBLANK?
What are some other functions that are similar to COUNT?
