{"id":764,"date":"2018-06-30T17:08:05","date_gmt":"2018-06-30T17:08:05","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=764"},"modified":"2024-03-29T14:24:54","modified_gmt":"2024-03-29T14:24:54","slug":"count-cells-that-are-not-blank","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/","title":{"rendered":"Count Cells that are Not Blank in Excel"},"content":{"rendered":"\n
COUNTA<\/h2>\n\n\n\n
This function will return the number of cells that are not empty. It checks whether cells contain any type of value, such as text, number, dates, or even errors. It doesn\u2019t count cells that are blank.<\/p>\n\n\n\n
Take a look at the example below.<\/p>\n\n\n\n
We will use the following formula.<\/p>\n\n\n\n
=COUNTA(A1:E2)<\/pre>\n\n\n\n<\/figure>\n\n\n\n
Each cell in the range from A1<\/strong> to E2,<\/strong> except cell D2,<\/strong> is not empty, so the result is 9<\/strong>.<\/p>\n\n\n\n
COUNTBLANK<\/h2>\n\n\n\n
The function opposite to COUNTA<\/strong> is COUNTBLANK.<\/strong> It counts only cells that are empty.<\/p>\n\n\n\n<\/figure>\n\n\n\n
Only cell D2<\/strong> is empty, so the result is 1<\/strong>.<\/p>\n\n\n\n
COUNTIF<\/h2>\n\n\n\n
There is another, more complicated example. Using this function, you can count both blank and non-blank cells<\/strong>.<\/p>\n\n\n\n
In order to count non-blank<\/strong> cells use the following formula.<\/p>\n\n\n\n
=COUNTIF(A1:E2,\"<>\"&\"\")<\/pre>\n\n\n\n
To count blank cells<\/strong>, change \u201c<>\u201d<\/strong> to \u201c=\u201d<\/strong>.<\/p>\n\n\n\n
=COUNTIF(A1:E2,\"=\"&\"\")<\/pre>\n\n\n\n
This is our final result.<\/p>\n\n\n\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
COUNTA This function will return the number of cells that are not empty. It checks whether cells contain any type of value, such…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[190],"yoast_head":"\n
Count Cells that are Not Blank in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to use COUNTA, COUNTBLANK, and COUNTIF in Excel to count non-empty cells, empty cells, and cells that meet certain criteria. Example formulas included.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Count Cells that are Not Blank in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to use COUNTA, COUNTBLANK, and COUNTIF in Excel to count non-empty cells, empty cells, and cells that meet certain criteria. Example formulas included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-30T17:08:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T14:24:54+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Count Cells that are Not Blank in Excel\",\"datePublished\":\"2018-06-30T17:08:05+00:00\",\"dateModified\":\"2024-03-29T14:24:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\"},\"wordCount\":164,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\",\"name\":\"Count Cells that are Not Blank in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png\",\"datePublished\":\"2018-06-30T17:08:05+00:00\",\"dateModified\":\"2024-03-29T14:24:54+00:00\",\"description\":\"Learn how to use COUNTA, COUNTBLANK, and COUNTIF in Excel to count non-empty cells, empty cells, and cells that meet certain criteria. Example formulas included.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Count Cells that are Not Blank in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Count Cells that are Not Blank in Excel","description":"Learn how to use COUNTA, COUNTBLANK, and COUNTIF in Excel to count non-empty cells, empty cells, and cells that meet certain criteria. Example formulas included.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/","og_locale":"en_US","og_type":"article","og_title":"Count Cells that are Not Blank in Excel","og_description":"Learn how to use COUNTA, COUNTBLANK, and COUNTIF in Excel to count non-empty cells, empty cells, and cells that meet certain criteria. Example formulas included.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/","article_published_time":"2018-06-30T17:08:05+00:00","article_modified_time":"2024-03-29T14:24:54+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Count Cells that are Not Blank in Excel","datePublished":"2018-06-30T17:08:05+00:00","dateModified":"2024-03-29T14:24:54+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/"},"wordCount":164,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png","keywords":["pinterest"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/","url":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/","name":"Count Cells that are Not Blank in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png","datePublished":"2018-06-30T17:08:05+00:00","dateModified":"2024-03-29T14:24:54+00:00","description":"Learn how to use COUNTA, COUNTBLANK, and COUNTIF in Excel to count non-empty cells, empty cells, and cells that meet certain criteria. Example formulas included.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/count-cells-that-are-not-blank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Count Cells that are Not Blank in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/764"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"predecessor-version":[{"id":17398,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/764\/revisions\/17398"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/counta.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/countblank.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/final-example.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"