You can pass "<>" (including the quotes) as the parameter for criteria. This basically says, as long as its not empty/blank, count it. I believe this is what you want.
=COUNTIF(A1:A10, "<>")
Otherwise you can use CountA as Scott suggests
Google Support
support.google.com › docs › answer › 3093480
COUNTIF - Google Docs Editors Help
Otherwise, criterion may be a string containing a number (which also checks for equality), or a number prefixed with any of the following operators: =, >, >=, <, or <=, which check whether the range cell is equal to, greater than, greater than or equal to, less than, or less than or equal to the criterion value, respectively. COUNTIF can only perform conditional counts with a single criterion.
Excel Insider
excelinsider.com › home › our blog › google sheets functions › how to count cells with values in google sheets (4 ways)
How to Count Cells with Values in Google Sheets (4 Ways) - Excel Insider
June 26, 2025 - Learn how to count cells with values in Google Sheets using COUNTA, COUNTIF, COUNT, and COUNTBLANK functions for accurate data tracking.
How to count cells with any text in them.
Counta should do the trick
More on reddit.com 6
1
August 2, 2022google sheets - How to count number of non-blank cells (cells that contain text)? - Stack Overflow
If you have cells with something like ="" and don't want to count them, you have to subtract number of empty cells from total number of cell by formula like ... Tested at google docs. ... Save this answer. ... Show activity on this post. COUNTIF function can count cell which specific condition where as COUNTA will count all cell which contain any value... More on stackoverflow.com
How do I count the number of cells, in a range of cells, whose values fall within a specified range - 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 number of cells with any value (string or number) in a column in Google Docs Spreadsheet - Stack Overflow
I have several columns in Google Spreadsheet. I would like to count how many cells have a value (number or string) and display that number at the top of the column. For example: Hello World 1... More on stackoverflow.com
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
How to Use The COUNTIF Google Sheets Function - Coefficient
What is Coefficient's AI Sheets Assistant?
AI Sheets Assistant is Coefficient's AI-powered feature that helps you build formulas, create charts, generate pivot tables, and build entire dashboards using natural language commands in Google Sheets. Unlike generic AI assistants, it's context-aware and creates native Google Sheets objects that are live and editable. It understands your spreadsheet's layout and data structure to provide accurate, actionable results.
coefficient.io
coefficient.io › home
How to Use The COUNTIF Google Sheets Function - Coefficient
How does Coefficient's automated refresh work?
Coefficient allows you to schedule automatic data refreshes at intervals you choose: hourly (1, 2, 4, or 8 hours), daily, weekly, or monthly. Once scheduled, your spreadsheet data automatically updates from your connected systems without any manual work. You can also trigger manual refreshes anytime with an on-sheet button or through the sidebar.
coefficient.io
coefficient.io › home
How to Use The COUNTIF Google Sheets Function - Coefficient
01:49
How Count Cells With Specific Text in Google Sheets - YouTube
06:10
Google Sheets: how to use COUNT, COUNTA, and COUNTIF - YouTube
06:03
Using the COUNTIF Function in Google Sheets - YouTube
02:00
Google Sheets: how to count cells with specific text! - YouTube
How Count Cells With Specific Text in Google Sheets
01:43
How to Use COUNTIF in Google Sheets for Attendance - YouTube
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › count and counta functions in google sheets with formula examples
COUNT and COUNTA functions in Google Sheets with formula examples
May 5, 2023 - The syntax of Google Sheets COUNT and its arguments is as follows: ... Value1 (required) — stands for a value or a range to count within. Value2, value3, etc. (optional) — additional values that are going to be covered as well. What can you use as an argument? The value itself, cell reference, range of cells, named range.
W3Schools
w3schools.com › googlesheets › google_sheets_count.php
Google Sheets COUNT Function
The COUNT function is a premade function in Google Sheets, which counts cells with numbers.
Reddit
reddit.com › r/googlesheets › how to count cells with any text in them.
r/googlesheets on Reddit: How to count cells with any text in them.
August 2, 2022 -
Hey r/googlesheets, long time listener, first time caller, here with kind of a dumb question.
I'm making a guest list. First name is column A, last name is column B, "Plus one?" is column C, with a dropdown menu. What function would I use to count all the cells in column A that have text in them. Ultimately, I want a cell with the total number of guests.
Thanks in advance.
Top answer 1 of 5
4
Counta should do the trick
2 of 5
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
Top answer 1 of 9
316
You can pass "<>" (including the quotes) as the parameter for criteria. This basically says, as long as its not empty/blank, count it. I believe this is what you want.
=COUNTIF(A1:A10, "<>")
Otherwise you can use CountA as Scott suggests
2 of 9
35
COUNTIF function will only count cells that contain numbers in your specified range.
COUNTA(range) will count all values in the list of arguments. Text entries and numbers are counted, even when they contain an empty string of length 0.
Example: Function in A7 =COUNTA(A1:A6)
Range:
A1 a
A2 b
A3 banana
A4 42
A5
A6
A7 4 -> result
Google spreadsheet function list contains a list of all available functions for future reference https://support.google.com/drive/table/25273?hl=en.
Owox
owox.com › blog › articles › google sheets tips › how to use the count and counta functions in google sheets: a complete guide
Using COUNT and COUNTA Functions in Google Sheets in 2025
June 1, 2026 - In contrast, the COUNT function only counts cells with strictly numeric values, excluding any cells that contain text. The COUNTA function in Google Sheets counts all cells with data, whether they contain text, numbers, logical values (TRUE/FALSE), ...
Rows
rows.com › blog › post › countif-formula-in-google-sheets
How to Use the COUNTIF Google Sheets Function in 2025
August 19, 2024 - Follow the steps above for Google Sheets. Type the COUNTIF syntax in an empty cell to draft the value you want. In this case, we check the number of times “David” appears in the A column.
Coefficient
coefficient.io › home
How to Use The COUNTIF Google Sheets Function - Coefficient
September 2, 2025 - Now that we have our dataset let’s dive into some step-by-step examples of COUNTIF in Google Sheets. As discussed, you can use a COUNTIF formula to count the number of cells within a data range that contain a specific text or numeric value.
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › google spreadsheet countif function with formula examples
Google Spreadsheet COUNTIF function with formula examples
The better decision would be to write the criteria down other Google Sheets cell and reference that cell in the formula. Let's count the number of occurred sales in the "West" region using the cell reference in COUNTIF. We'll get the following formula: ... The function uses the content of A3 (the text value "West") in its calculations.
Published: August 16, 2021
Views: 45
Google Support
support.google.com › docs › thread › 172551513 › how-do-i-count-the-number-of-cells-in-a-range-of-cells-whose-values-fall-within-a-specified-range
How do I count the number of cells, in a range of cells, whose values fall within a specified range - Google Docs Editors Community
July 25, 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
Layer
golayer.io › home › countif & countifs in google sheets: formula & examples
COUNTIF & COUNTIFS in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - In Google Sheets, you can use the COUNTIFS function to count cells based on multiple criteria, and each criterion can be applied to a different range. For example, you can count the sales of a specific product with values greater than a particular ...
Arab Psychology
scales.arabpsychology.com › home › how to easily count rows with specific values in google sheets
How To Count Rows With Value In Google Sheets (3 ...
December 1, 2025 - The following examples show how to use each method with a practical dataset provided in Google Sheets: The primary tool for conditional counting in spreadsheets is the COUNTIF function.
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › google sheets count cells with text | full guide
Google Sheets Count Cells with Text | Full Guide for 2026
Using this function, Google Sheets will count cells that contain a value in the range, providing it meets the criterion.
Published: September 9, 2025
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › how to use the countif google sheets function [easy guide]
How to Use the COUNTIF Google Sheets Function [Easy Guide]
January 4, 2024 - With this in mind, you can use COUNTIF to count all the cells in a given range that are either ticked or not. For the sake of the next example, we manipulated some data and added another column with checkboxes that tell whether a student passed or failed. You can use this formula to look up the number of students who passed by counting checkboxes in Google Sheets with a value ...
Statology
statology.org › home › how to count rows with value in google sheets (3 examples)
How to Count Rows with Value in Google Sheets (3 Examples)
January 19, 2022 - We can use the following formula to count the number of rows with a value of “8” in column B: ... We can see that there are 3 rows with a value of “8” in the Points column. The following tutorials explain how to perform other common operations in Google Sheets: Google Sheets: How to Filter for Cells that Contain Text Google Sheets: How to Use SUMIF with Multiple Columns Google Sheets: How to Sum Across Multiple Sheets
Owox
owox.com › blog › articles › google sheets tips › how to master countif and countifs in google sheets
How to Master COUNTIF and COUNTIFS in Google Sheets
June 1, 2026 - The COUNTIF and COUNTIFS functions in Google Sheets provide a flexible way to count cells based on specified conditions using logical operators such as: ... These operators allow you to filter and count data based on numeric thresholds, for example, values greater than 500 or not equal to 0, making them essential for dynamic data analysis.
Finofo
finofo.com › advanced-google-spreadsheet › count-rows-in-google-sheets-a-step-by-step-guide
Count Rows in Google Sheets: A Step-by-Step Guide
Input the COUNT Formula: Type =COUNT(B:B) for counting only numeric values within a column. Replace B:B with the column containing the numbers you want to count. Execute the Formula: Hit enter to see the count of numeric cells in your selected ...
Top answer 1 of 5
119
In the cell you want your result to appear, use the following formula:
=COUNTIF(A1:A200,"<>")
That will count all cells which have a value and ignore all empty cells in the range of A1 to A200.
2 of 5
19
You could also use =COUNTA(A1:A200) which requires no conditions.
From Google Support:
COUNTA counts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace). To count unique values, use COUNTUNIQUE.
The Bricks
thebricks.com › home › resources › how to use count in google sheets: a step-by-step guide
How to Use COUNT in Google Sheets: A Step-by-Step Guide
April 22, 2025 - The most straightforward counting function is COUNT. Its one and only job is to count the number of cells within a given range that contain numeric values. This includes numbers, dates, and times, as they are all stored as numbers in Google Sheets.