Mastering Counts in Google Sheets: A Step-by-Step Guide

Grace Jul 17, 2026

Learn how to perform counting in Google Sheets with ease. This versatile tool offers several built-in functions that make counting cells a breeze. Whether you're tallying unique values or needing to count non-blank cells, Google Sheets has you covered.

How to Count Words in Google Sheets
How to Count Words in Google Sheets

Before we dive in, ensure you have Google Sheets open and a sample dataset to work with. For this guide, let's imagine we have a list of fruits in column A (A2:A10), with some cells left blank.

How to use Master the UNIQUE & COUNTIF Functions in Google Sheets:
How to use Master the UNIQUE & COUNTIF Functions in Google Sheets:

Counting Cells with Data (COUNT completely)

The COUNT function is perfect for counting cells with any data, whether numbers or text. It ignores blank cells and errors.

How to use COUNT function in Excel and Google Sheets?
How to use COUNT function in Excel and Google Sheets?

Formula: `=COUNT(range)`.

Counting Fruits

How to Number Rows in Google Sheets (Add Serial Numbers)
How to Number Rows in Google Sheets (Add Serial Numbers)

To count the total fruits, use `=COUNT(A2:A10)`. This will ignore blank cells and count 'Apple', 'Banana', 'pear', etc.

Tip: Make sure to start your range from the cell containing the first data point (A2, not A1).

Counting "Banana"

How to Use COUNTA on Google Sheets, Infographic
How to Use COUNTA on Google Sheets, Infographic

The COUNTIF function counts cells that meet a specific criterion. To count 'Banana's, use `=COUNTIF(A2:A10, "Banana")`.

дон' - Use double quotes for 'Banana' and enclose the function in single quotes (`).

Counting Non-Blank Cells (COUNTA)

Google Sheets Tips COUNTIFS Function, Infographic
Google Sheets Tips COUNTIFS Function, Infographic

COUNTA counts all non-blank cells, treated as errors. If you have a mix of numbers and text, COUNTA is your go-to.

Formula: `=COUNTA(range)`.

How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
COUNT functions in google sheet or excel
COUNT functions in google sheet or excel
How to Count Unique Values In Google Sheets
How to Count Unique Values In Google Sheets
How to Use COUNTIF on Google Sheets, Infographic
How to Use COUNTIF on Google Sheets, Infographic
COUNT vs COUNTA vs COUNTBLANK vs COUNTIF - Explained Clearly
COUNT vs COUNTA vs COUNTBLANK vs COUNTIF - Explained Clearly
How To Get Word Count in Google Sheets
How To Get Word Count in Google Sheets
How to Count Work Hours in Google Sheets with Example | Step-by-Step Guide
How to Count Work Hours in Google Sheets with Example | Step-by-Step Guide
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
How To Use COUNTIF In Google Sheets | Formula Quick Guide
How To Use COUNTIF In Google Sheets | Formula Quick Guide

Counting All Fruits (including blanks)

To count every cell in column A, use `=COUNTA(A2:A10)`. This will count blanks and values, while COUNT would only count the values.

處 - To count by rows instead, use `=COUNTA(A2:A)`. 'A2:A' tells the function to count every cell from row 2 downwards in column A.

Counting "Banana" (including blanks)

To count 'Banana's, including any surrounding blank cells, use `=COUNTAIF(A2:A10, "Banana")`. This function checks each cell, seeing if it contains 'Banana'.

If you prefer, use '=' instead of '*' to check for an exact match.

Counting Unique Values (UNIQUE)

UNIQUE counts the number of unique values within your range, disregarding duplicates.

Formula: `=UNIQUE(range)`.

Counting Unique Fruits

To find the unique fruits, use `=UNIQUE(A2:A10)`. This will return a list of distinct fruits and ignore duplicates.

Tip: Wrap the function in an ARRAYFORMULA to count or summarize the output, e.g., `=COUNTUNIQUE(A2:A10)` will count the number of unique fruits.

From data analysis to reporting, these counting functions make Google Sheets your versatile partner. Start exploring and unlock new possibilities today!