New Webinar! Tech & Workflow Automation: Optimize Your Growth Strategy
Back to guides

# COUNTBLANK Function in Google Sheets: Explained

## What is Google Sheets’ COUNTBLANK formula?

This function counts the number of blank cells in the selected range.

100+ templates, all free to use.

## How to use the COUNTBLANK function in Google Sheets

• Type “=COUNTBLANK” or go to “Insert”“Function” (or directly navigate to the “Functions” icon)  “Math”“COUNTBLANK”.

• Select a range or an array including blank cells whose numbers you need to calculate

• Press the “Enter” key.

Sheets tutorials availalble now in our free certificate program!
Learn basic and intermediate functions with digestible videos and instructions.

The general syntax is as follows:

``=COUNTBLANK(value1, [value2, …])``

`‍`

`Value1: This argument should be a cell, range, or array.`

`‍`

`Value2: If you need to select other ranges, you can add as value2, value3, ….`

`‍`

`Note`

1. `The COUNTBLANK function counts the total number of blank cells. So, even when empty cells appear several times in a data set, they are calculated individually.`
2. `The function doesn’t count the number of cells incorporating any values, including ones containing only whitespace(s).`
3. `Ensure all cells you want to count don’t have hidden text such as “‘“, an apostrophe.`

`‍`

`The following screenshot presents how the function works in Google Sheets. As there are two entirely blank cells in the selected range, the formula returns two.`

`‍`

`‍`

`‍`

## `How do I count filled cells in Google Sheets?`

`‍`

`You can use COUNT, COUNTA, or COUNTUNIQUE depending on your purpose.`

`‍`

`COUNT: This formula is effective when you want to calculate the number of numeric values including date and time.`

`‍`

`COUNTA: This function is helpful when you want to count the number of all values except for blank cells.`

`‍`

`COUNTUNIQUE: This formula is useful when you need to compute the number of unique values (excluding duplicates) in a range.`

`‍`

``` The world's top businesses trust LiveFlow to automate their financial reporting We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST! Book a Demo ```

`Learn how to do this step-by-step in the video below 👇`

### `Get personal help`

`We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.`
`Chat on Intercom`
`Email us at: help@liveflow.io`

## `Liked this article? Then you'll love the ones below`

`PRODUCT Function in Google Sheets: Explained`
`MINUS Function in Google Sheets: Explained`
`ADD Function in Google Sheets: Explained`
`DIVIDE Function in Google Sheets: Explained`
`MULTIPLY Function in Google Sheets: Explained`
`SEQUENCE Function in Google Sheets: Explained`
`RANDARRAY Function in Google Sheets: Explained`
`RANDBETWEEN Function in Google Sheets: Explained`
`RAND Function in Google Sheets: Explained`
`MOD Function in Google Sheets: Explained`
`COUNTA Function in Google Sheets: Explained`
`COUNT Function in Google Sheets: Explained`

## `Supercharge your financial reporting today`

`See LiveFlow in action and discover how to streamline your workflows.`

`‍‍‍`
``` window.onload = () => { window.hljs.configure({ languages: ["excel"] }); document.querySelectorAll('pre code').forEach((el) => { window.hljs.highlightElement(el); }); }; { "@context": "https://schema.org", "@type": "BlogPosting", "mainEntityOfPage": { "@type": "WebPage", "@id": "https://www.liveflow.io/product-guides/countblank-function-in-google-sheets" }, "headline": "COUNTBLANK Function in Google Sheets: Explained", "image": "https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/6470f08f2718a7b0dd73aa70_2022-10-22%2009%2059%2039.png", "author": { "@type": "Organization", "name": "LiveFlow", "url": "https://www.liveflow.io/" }, "publisher": { "@type": "Organization", "name": "LiveFlow", "logo": { "@type": "ImageObject", "url": "https://cdn.prod.website-files.com/61f27b4a37d6d702688002ba/61f27b4a37d6d7680b800301_LiveFlow%20Logo%20Deep%20Blue%20%5Bupdated%5D.png" } }, "datePublished": "Oct 22, 2022", "dateModified": "Jan 31, 2024", "description" : "Learn the COUNTBLANK function and how to use it in Google Sheets" } jQuery(document).ready(function() { jQuery(".rich-text-main a").attr("target", "_blank").attr("rel", "noopener noreferrer"); }); ```