Tutorials References Exercises Bootcamps Videos Menu
Sign Up Create Website Get Certified Upgrade

Google Sheets COUNT Function

COUNT Function

The COUNT function is a premade function in Google Sheets, which counts cells with numbers.

It is typed =COUNT and gets a list of cells:

=COUNT(value1, [value2, ...])

You can select cells one by one, but also ranges, or even multiple ranges.

Note: The COUNT function only counts cells with numbers, not cells with letters. The COUNTA function is used if the cells have letters.

Count Function Example

Apply the =COUNT function to range D2:D21. Counting the cells of Pokemon Total stats, which is numbers only:

Copy Values

COUNT function, step by step:

  1. Select the cell D22
  2. Type =COUNT
  3. Click the COUNT command

  1. Specify range D2:D21
  2. Hit enter

That's it! The =COUNT function successfully counted 20 cells with numbers.

A Non-Working Example

Now, let us try an example that will not work.

Apply the =COUNT function to the range A2:A21, which only has cells with letters.

It returns the value 0, no cells with numbers found. Range A2:A21 only had cells with letters.