COUNT

Formulas / COUNT
To 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 3

    The 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 1

    The 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 3

    The 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:A10

    The 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?
The COUNT function is a function that counts cells with numeric values.
How does the COUNT function work?
The COUNT function returns a total count of the specified numeric values. It only counts cells with numeric data.
What does the COUNT function return?
The COUNT function returns the total count of numeric values only.
Where can I use the COUNT function?
The COUNT function works on any range of cells.
What's the difference between COUNT and COUNTBLANK?
Use COUNTBLANK instead of COUNT to count cells that are blank or empty. Use COUNT if you want to only count cells that have numbers as values.
What are some other functions that are similar to COUNT?
COUNT is similar other functions like COUNTA, COUNTIF, COUNTBLANK, and COUNTIFS.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.