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
Count 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, 2024Count blank cells only if the other cells in that row aren't blank
Yes, =COUNTA(B2:B)-COUNTA(K2:K) should be fine with your data. Simple is better. If this works, please respond with Solution Verified If not, feel free to post any follow-up questions Hope this helps, HBAB More on reddit.com
8
4
June 7, 2021How 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.
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.
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.
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.
Ok Sheets
oksheets.com › count-nonblank-cells
6 Ways to Count Non-Blank Cells in Google Sheets | Ok Sheets
Copy and paste the above formula into an empty cell to count the number of nonblank cells in Column B. You can expand the size of the range or add more ranges as you like. You can also use the COUNT function to count all the nonblank cells in your data. But this will only count number values in your dataset. ... The COUNT function has the same arguments as COUNTA. ... You should note that the COUNT and COUNTA functions, although very similar, differ quite slightly in terms of what they count.
The Bricks
thebricks.com › home › resources › how to count filled cells in google sheets
How to Count Filled Cells in Google Sheets - Bricks
April 22, 2025 - Google Sheets will look at every cell from B2 to B11 and count how many of them have an entry. It will ignore the blank cell (B7 in this example) and give you a total count of the filled cells. A Quick Tip: Be aware that COUNTA counts cells containing formulas that return an empty string ("") as well as cells that only have a space. It’s looking for anything that makes the cell "not empty."