I just used =COUNTIF(Range, "<>") and it counted non-empty cells for me.
Top answer 1 of 14
218
I just used =COUNTIF(Range, "<>") and it counted non-empty cells for me.
2 of 14
138
=counta(range)
counta: "Returns a count of the number of values in a dataset"Note:
CountAconsiders""to be a value. Only cells that are blank (press delete in a cell to blank it) are not counted.Google support: https://support.google.com/docs/answer/3093991
countblank: "Returns the number of empty cells in a given range"Note:
CountBlankconsiders both blank cells (press delete to blank a cell) and cells that have a formula that returns""to be empty cells.Google Support: https://support.google.com/docs/answer/3093403
If you have a range that includes formulae that result in "", then you can modify your formula from
=counta(range)
to:
=Counta(range) - Countblank(range)
EDIT: the function is countblank, not countblanks, the latter will give an error.
Simular
simular.ai › workflow › how-to-count-non-empty-cells-in-google-sheets-fast
How to Count Non-Empty Cells in Google Sheets (COUNTA Guide)
1 month ago - Quick answer: To count non-empty cells in Google Sheets, use =COUNTA(range), which counts every cell that is not blank. To count by condition use COUNTIF, and to ignore cells that only look empty (formulas returning "") use SUMPRODUCT.
How to count if cell is not empty AND satisfies another criterion?
What column is supposed to be counted? A:A? If so, you can use a combination of FILTER and COUNTA. Try this formula: =COUNTA(IFERROR(FILTER(A:A,A:A<>"",B:B=$X$1))) If that solved your issue, please mark the thread as solved by answering Solution Verified to my comment. More on reddit.com
8
1
November 9, 2022Formula to Count Non-Blank Cells - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
Countifs cell not blank
If it’s a true blank “<>” for the criteria. Won’t work if it contains an empty string. For the opposite, “” for the criteria. Will match blanks and empty strings. If you need to exclude blanks and empty strings you can do something like this: arrayformula(D1:D10<>””), true Or index() for short. So: =COUNTIFS(A1:A10;1;B1:B10;$C$1; index(D1:D10<>””); true) This converts your D1:D10 range to an array of true/false values which you then count if true More on reddit.com
7
2
May 10, 2025Count non-blank columns in a range
Give this a try: =COUNTIF(BYCOL(D9:AF,LAMBDA(c,SUM(c))),">0") Basically sums each column. If any column sum is greater than zero, that column is counted as a "non-blank" day. This accounts for the entire column starting from row 9. Edit - using the range you specified in your post: =COUNTIF(BYCOL(D9:AC31,LAMBDA(c,SUM(c))),">0") More on reddit.com
27
2
November 10, 2024How can I identify non-blank cells without counting them?
You can identify non-blank cells by applying conditional formatting in Google Sheets. This feature allows you to highlight cells that are not blank, making them easier to spot visually without needing to count them.
superjoin.ai
superjoin.ai › home › blog › how to count cells if not blank in google sheets
How to Count Cells if Not Blank in Google Sheets | Superjoin
Can I count cells that are not blank and have a specific background color?
Google Sheets does not have a built-in function to count cells based on background color. However, you can use a custom Google Apps Script to count cells that are not blank and have a specific background color.
superjoin.ai
superjoin.ai › home › blog › how to count cells if not blank in google sheets
How to Count Cells if Not Blank in Google Sheets | Superjoin
Does Coefficient work with both Google Sheets and Excel?
Yes, Coefficient supports both Google Sheets and Microsoft Excel. You can install Coefficient from the Google Workspace Marketplace for Sheets or from Microsoft AppSource for Excel.
coefficient.io
coefficient.io › home
Counting Non-Empty Cells in Google Sheets: A Quick Guide
02:55
How to Quickly Count Non-Empty Cells With COUNTA in Google Sheets ...
02:17
How to Count Non Empty Cells in Google Sheets - YouTube
02:40
How to count non empty cells in Google Sheets | 3 easy methods ...
04:35
Count Cells That DON'T Contain Certain Text – Google Sheets - ...
01:56
Excel COUNTIF not blank ✅ in 1 MINUTE - YouTube
02:11
How to Count Empty or Blank Cells in Google Sheets - YouTube
Superjoin
superjoin.ai › home › blog › how to count cells if not blank in google sheets
How to Count Cells if Not Blank in Google Sheets | Superjoin
August 21, 2024 - One of the most straightforward methods to count cells that are not blank is by using the COUNTA function. This function counts the number of cells in a range that are not empty, making it ideal for most use cases.
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › google sheets countif not blank: 4 easy ways
Google Sheets COUNTIF Not Blank: 4 Easy Ways | SSP
All I do is select the cells in which you want to get the count of cells that are not blank and see the COUNT value in the taskbar (in the bottom-right part of the Google Sheets document).
Published: February 14, 2025
Sheetai
sheetai.app › blog › google-sheets-count-if-not-blank
Google Sheets Count if not blank
May 13, 2025 - This counts all the non-blank cells in the range A1 to A10. The "<>" condition means “not equal to blank”. Once you hit Enter, Google Sheets will calculate and display the number of non-empty cells in that range.
Coefficient
coefficient.io › home
Counting Non-Empty Cells in Google Sheets: A Quick Guide
February 10, 2024 - One of the easiest ways to count non-empty cells in Google Sheets is by using the COUNTA function. This function counts the number of cells in a range that are not empty.
Reddit
reddit.com › r/googlesheets › how to count if cell is not empty and satisfies another criterion?
r/googlesheets on Reddit: How to count if cell is not empty AND satisfies another criterion?
November 9, 2022 -
Hi, I am trying to find a formula that says
count IFS (Cell in column A is not empty, AND cell in column B is equal to $X$1)
I am really struggling to find a way to define "column A is not empty" along with a different criteria. Any tips?
Edit: Data is similar to:
| Name | Country | Date |
|---|---|---|
| Rob | Austria | 23-03-22 |
| Maria | Germany | |
| Anna | Austria | |
| Luigi | Italy | 24-03-22 |
With multiple names, countries, and the presence or absence of a date
I only want to count how many names are in Austria and have a date, any date.So my problem is: count Names IF(s) Country=Austria and Date is NOT blank
Working solution:
This finally worked! Like this:
=COUNTA(FILTER(A:A,B:B =Austria,C:C<>""))
Top answer 1 of 3
1
What column is supposed to be counted? A:A? If so, you can use a combination of FILTER and COUNTA. Try this formula: =COUNTA(IFERROR(FILTER(A:A,A:A<>"",B:B=$X$1))) If that solved your issue, please mark the thread as solved by answering Solution Verified to my comment.
2 of 3
1
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: Fewer Letters | More Letters | AND | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false | Last usage | Returns the a count of the number of values in a dataset | FALSE | Returns the logical value FALSE | Last usage | Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions | Last usage | Returns one value if a logical expression is TRUE and another if it is FALSE | Last usage | Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent | Last usage | Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE | TRUE | Returns the logical value TRUE [Thread #5054 for this sub, first seen 8th Nov 2022, 16:17] [FAQ] [Full list] ^[Contact] [Source code]
Google Support
support.google.com › docs › thread › 191532096 › formula-to-count-non-blank-cells
Formula to Count Non-Blank Cells - Google Docs Editors Community
December 5, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Excel Insider
excelinsider.com › home › our blog › google sheets functions › how to count non-empty cells in google sheets
How to Count Non-Empty Cells in Google Sheets - Excel Insider
July 7, 2025 - Learn how to count non-empty cells in Google Sheets using COUNTA, COUNTIF, and ARRAYFORMULA while filtering spaces and applying conditions.
Google Sheets
sheetsformarketers.com › home › blog › how to count non-empty cells in google sheets
How To Count Non-Empty Cells in Google Sheets - Sheets for Marketers
January 10, 2023 - In Google Sheets, there are a few ways you can count non-empty cells. The COUNTA function counts the number of cells in a range that are not empty. We can also use the COUNTIF function since it counts the number of cells that meet certain criteria.
Excel Insider
excelinsider.com › home › our blog › google sheets functions › how to use countif to count non-blank cells in google sheets
How to Use COUNTIF to Count Non-Blank Cells in Google Sheets - Excel Insider
July 31, 2025 - ➤ Press Enter to display the count of filled email addresses in the dataset. ... The most straightforward method to count non-blank cells in Google Sheets is by using the COUNTIF function.
Productivity Spot
productivityspot.com › home › functions & formulas › how to use countif to count cells that are not blank
How to Use COUNTIF to Count Cells That Are Not Blank
December 1, 2023 - If you have a dataset like we have below and you want to Google Sheets to count cells with text, you can use the following steps. Click or select a blank cell. Input the COUNTA function.
MakeUseOf
makeuseof.com › home › productivity › how to count non-blank cells in google sheets
How to Count Non-Blank Cells in Google Sheets
August 4, 2022 - If we use COUNTA here, it will add the cell with just the space, even though it is considered empty. In these cases, using COUNTIF instead of COUNTA will provide a more accurate count of the cells that are not blank. COUNTIF is one of the many ...
InfoInspired
infoinspired.com › home › google docs › spreadsheet › countif not blank in google sheets: common mistakes and fixes
How to Count If Not Blank in Google Sheets [Tips and Tricks]
July 4, 2026 - HomeGoogle DocsSpreadsheetCOUNTIF Not Blank in Google Sheets: Common Mistakes and Fixes ... COUNTIF not blank is the easiest way to count non-empty cells in Google Sheets. Whether you’re counting completed entries, products, employees, or other data, the COUNTIF function can quickly return the total.
How-To Geek
howtogeek.com › home › web › how to count blank or empty cells in google sheets
How to Count Blank or Empty Cells in Google Sheets
December 13, 2019 - If you want to know the number of truly empty cells, you'll need to use a combination of the SUM, ROWS, COLUMNS, and COUNTIF functions. You can try the COUNTBLANK function to count the number of blank cells in a Google Sheets spreadsheet. This ...
The Bricks
thebricks.com › home › resources › how to countif not blank in google sheets
How to CountIF Not Blank in Google Sheets
February 20, 2025 - To make it count non-blank cells, you need to use the "not equal to" operator, which is written as <,>,. When you combine this operator with an empty set of quotation marks (""), you're essentially telling Google Sheets to count any cell ...
Software Accountant
softwareaccountant.com › count-if-not-blank-in-google-sheets
Count If NOT Blank In Google Sheets (Count Non-Empty Cells)
September 14, 2023 - It’s not just about having a cursory glance at the sheet; you need an efficient and accurate method to count these non-empty cells. This is where the prowess of Google Sheets’ COUNT formulas comes into play.
ExcelMojo
excelmojo.com › home › google sheets › google sheets math functions › count non-empty cells in google sheets
Count Non-Empty Cells In Google Sheets - How To Count?
April 23, 2026 - Next, insert the COUNTA formula. So, the complete formula is =COUNTA(A2:A6). Press Enter key. We will be able to see the result in Google sheets in cell A8, as shown in the below image. In this article, let us learn how to use functions in Google sheets to count the non-empty cells.
Reddit
reddit.com › r/googlesheets › countifs cell not blank
r/googlesheets on Reddit: Countifs cell not blank
May 10, 2025 -
Hello, I need to use the function countifs for multiple criteria, including "the cell is not blank". Here is an example. Be aware that I use semicolon to separate formulas, not commas like in the USA.
COUNTIFS(A1:A10;1;B1:B10;$C$1;D1:D10; not blank)
Translated, count all the cells that in the column A are equal to 1, in the column B are equal to C1, and in the column D are not blank. For instance, if A5=1, B5=C1 and D5 is not blank, then count it.
It works perfectly with other criteria, but I cannot find anything about cells not being blank. What line of code should I put?
As a bonus question, what if I revert the last condition, asking for cells that are blank in the D column, instead? What should I put in that case?
3Pie Analytics
3pieanalytics.com › excel-and-google-sheets-formulas-and-example › count-cells-that-are-not-blank-in-excel-or-google-sheets
count cells that are not blank in Excel and Google Sheets
To count the number of cells that are not blank, you can use =COUNTA(A2:A6) or =COUNTIF(A:A,"<>") formulas. Check the formulas below that suits your need. ... Check below for a detailed explanation with pictures and how to use formulas in Excel ...