COUNT Function in Google Sheets

Counting is a very fundamental operation for any spreadsheet related work. While there are a family of functions to help you in this regard, COUNT Function is certainly the most used in this arena.

While COUNT is a very straightforward and easy one to understand, there are still hidden nuances one should be aware of. In this article we’ll deep-dive into all the aspects of COUNT Function.

Purpose

Helps in counting number of distinct numerical values in a specified dataset.

Syntax and Parameter Definition

= COUNT(value1, [value2, value3, .....])
  1. value1: Can be a constant value(3,2,4 etc), cell reference(A2,B3 etc) or range(B1:B10) which will be considered for counting.

Rest of the arguments have the same definition as of value1, however, they are optional to supply

Expected Output

It returns count of number of numeric value in the provided values arguments. Below data elements will be counted:

  1. Numbers(Integers, Decimals & % included)
  2. Date
  3. Time

Data types like text, boolean, error will be ignored

Three main pointers to highlight:

  1. If the same numbers occurs twice then it will be counted twice
  2. Dates are inherent stored as numbers in Google Sheet, hence they’ll be counted as well
  3. Cells with blank values will be ignored

Note: To count cells containing any value(Number, Text, Date etc) use COUNTA instead of COUNT.

Examples

COUNT Function – Basic Example

In the below example, we have selected different type of data elements and applied Count Function over it.

COUNT Function Examples

As, per the definition only 5 highlighted cells were eligible to be counted and that’s what the results of count function is.

COUNT Function – Different Combination of Inputs types

From what was covered earlier, we know that we can supply inputs to COUNT as constant value, cell references or range.

The output in the below example is easy to understand, however, what is worth noting is different combinations of value inputs.

COUNT Function Examples

COUNT Function – Case of Repeated Numbers

COUNT Function doesn’t care about numbers getting repeated, rather it tells us count of all instances where numbers were found.

Below is the same example we used earlier. Notice we have replaced B4 from -2 to 10 making it similar to B3. The output(5) remains unchanged as expected.

COUNT Function Examples

COUNT Function – Case of blank/empty cells

COUNT Ignores any blank/empty cells coming it’s way. This is very well demonstrated by the below example.

COUNT Function Examples

Visual Demo of COUNT Function

Before we end here is a sample visual demonstration of COUNT Function in action.

COUNT Function GIF Demo

That’s it on this topic. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply