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
W3Schools
w3schools.com › googlesheets › google_sheets_count.php
Google Sheets COUNT Function
That's it! The =COUNT function successfully counted 20 cells with numbers. Now, let us try an example that will not work. Apply the =COUNT function to the range A2:A21, which only has cells with letters.
Google Support
support.google.com › docs › answer › 3093480
COUNTIF - Google Docs Editors Help
COUNTA: Returns the number of values in a dataset. COUNTBLANK: Returns the number of empty cells in a given range.
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
I want to count the cells that contain anything within a range. Any cell that contain text, or numbers or something else should do a plus one in my result-cell. I found this function, countif(ran... 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 much does Coefficient cost?
Coefficient offers 4 pricing tiers: Free Plan (3 connectors, forever free), Starter Plan ($59/user/month for individual users), Pro Plan ($99/user/month for 5 users), and custom Enterprise pricing. All paid plans include a 30-day free trial. Our Free trial let's you leverage our Pro plan at no cost so you can test the product with every feature available.
coefficient.io
coefficient.io › home
How to Use The COUNTIF Google Sheets Function - Coefficient
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 COUNT function in Google Sheets allows you to tally all cells with numbers within a specific data range. In other words, COUNT deals with numeric values or those that are stored as numbers in Google Sheets.
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.
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 - Yes, use COUNTIF(range, criterion). For example, =COUNTIF(B2:B20, “Approved”) counts how many cells contain the word “Approved” in that range. Counting cells based on value type in Google Sheets is straightforward once you understand ...
Rows
rows.com › blog › post › countif-formula-in-google-sheets
How to Use the COUNTIF Google Sheets Function in 2025
August 19, 2024 - Open your Google Sheet and input the formula into a cell. Replacing with your text criterion. Then press enter. ... This counts how many cells in B1:B20 contain a number greater than 100.
Google Support
support.google.com › docs › answer › 3093620
COUNT - Google Docs Editors Help
Returns the number of non null rows in a data column. ... COUNT for BigQuery counts both numeric and non-numeric values. ... Although COUNT is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.
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.
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.
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.
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 ...
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
Since it's locked from editing, here are the examples of formulas for your task using COUNTIFS: In B2: =COUNTIFS(Sheet1!$B$2:$B$13,B$1,Sheet1!$A$2:$A$13,">=01/01/2024",Sheet1!$A$2:$A$13,"<=01/31/2024") In C2: =COUNTIFS(Sheet1!$B$2:$B$13,C$1,Sheet1!$A$2:$A$13,">=01/01/2024",Sheet1!$A$2:$A$13,"<=01/31/2024") In B3: =COUNTIFS(Sheet1!$B$2:$B$13,B$1,Sheet1!$A$2:$A$13,">=02/01/2024",Sheet1!$A$2:$A$13,"<=02/28/2024") Adjust them for your other cells changing dates and cell references for countries accordingly. ... I have a column of data (amounting to a total of 148 values- including blank cells) all of which contained fractions, for ex."1/4" and whole numbers, for ex.
Published: August 16, 2021
Views: 45
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), ...
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
LiveFlow
liveflow.com › product-guides › count
COUNT Function in Google Sheets: Explained | LiveFlow
... Type “=COUNT(” or go to “Insert” → “Function” (or directly navigate to the “Functions” icon) → “Statistical” → “COUNT”. Select a range or an array containing numerical values whose numbers you want to count.
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
To count a cell with the same value in Google Sheets, use the COUNTIF function and the following steps: Select the cell where you want to display the count. ... Select the range of cells you want to count.
Published: September 9, 2025
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.
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 ...
Forms.app
forms.app › home › blog › data collection & analytics › how to use the countif function in google sheets
How to use the COUNTIF function in Google Sheets
July 8, 2024 - The COUNTIF function in Google Sheets (and Excel) counts the number of cells within a range that meets a specified condition. You can use COUNTIF to count the number of cells that contain a certain value, are greater than a certain value, or ...