Google Support
support.google.com › docs › answer › 3093991
COUNTA - Google Docs Editors Help
Returns the number of values in a dataset. Sample Usage COUNTA(A2:A100,B2:B100,4,26) COUNTA(1,2,3,4,5,C6:C20) Syntax COUNTA(value1, [value2, ...]) value1 - The first
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 quickest and simplest way would be to create a pivot table from the desired range: with the values you want to count as Rows and the COUNTA function as Values in it. If you're not familiar with pivot tables, feel free to read this blog post. ... How do you count how many times a particular figure appears in the sheet or in a column/selected range? ... It is COUNTIF that does that in Google Sheets.
google sheets - COUNTIF OR COUNTA - Stack Overflow
How do i use COUNTIF or COUNTA with a condition to count how many none blanks based on criteria across columns. What i hope to achieve: COUNTA Col B, Col C, Col J and Col F only IF Col A Contains S... More on stackoverflow.com
Incorrect Counting using COUNTA
Your IFNA() error condition is set to return the string "0", which is a non-blank entry and thus gets picked up by COUNTA(). To resolve the problem just eliminate that second argument entirely. More on reddit.com
20
1
July 18, 2025COUNT is counting blank results?
The following sheet provides clarification around how each of the Google Sheets count related functions work: https://docs.google.com/spreadsheets/d/1bPfbJJ-LwlRAIcjF9kK7BO_tWz-jWqpatG4bfleo5Vc/edit?usp=sharing COUNTIF(range_to_be_counted, "<>") tells the function to count cells that are not empty. This includes errors, zero-length strings, and whitespace. Some guidelines on which to use when: Use COUNT when you want the number of numerical values within a range Use COUNTA when you want the number of values of any type within a range, including errors, zero-length strings, and whitespace. Use COUNTBLANK when you want the number of blank cells within a range Use COUNTUNIQUE when you want the number of unique values within a range Use ROWS or COLUMNS when you want to determine the dimensions (in cells) of the range. Echoing u/marcnotmark925 , COUNTA(range_to_be_counted) should be used if the intention is to return the number of values within a range. More on reddit.com
9
1
July 22, 2024Countunique vs count(unique())?
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: Fewer Letters | More Letters | Last usage | Returns the a count of the number of numeric values in a dataset | Last usage | Returns the a count of the number of values in a dataset | Last usage | Counts the number of unique values in a list of specified values and ranges | Last usage | Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range 4 acronyms in this thread; the most compressed thread commented on today has 4 acronyms. [Thread #3677 for this sub, first seen 10th Dec 2021, 07:40] [FAQ] [Full list] ^[Contact] [Source code] More on reddit.com
3
2
December 10, 2021How To Use COUNTA Function In Google Sheets (Easiest Way ...
07:43
COUNT vs COUNTA in Google Sheets (Beginner Formula Tutorial) - YouTube
06:10
Google Sheets: how to use COUNT, COUNTA, and COUNTIF - YouTube
04:03
COUNTA Function: How to Use COUNTA in Google Sheets - YouTube
02:23
Google Sheets: How To Use the COUNTA Function - YouTube
02:34
COUNTING Values with the COUNTA Function in GOOGLE SHEETS - YouTube
LiveFlow
liveflow.com › product-guides › counta-function-in-google-sheets
COUNTA Function in Google Sheets: Explained | LiveFlow
The COUNTA function counts the number of all kinds of values, even when a specific value appears more than once in a data set. Even whitespace in a cell is considered a value and counted by the formula.
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 - COUNT helps you quickly tally numeric ... perfect for analyzing numerical data. COUNTA, on the other hand, counts all non-empty cells, including text and numbers, making it ideal for tracking any filled data....
W3Schools
w3schools.com › googlesheets › google_sheets_counta.php
Google Sheets COUNTA Function
That is great! The COUNTA function counts cells in a range with values both numbers and letters.
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 - Count Cells with Values in Google Sheets [Make a Copy] Use the COUNTA(range) function.
Sheetgo
sheetgo.com › home › how to use the counta function in google sheets
How to use the COUNTA function in Google Sheets - Sheetgo
December 17, 2020 - The COUNTA function in Google Sheets is a simple and widely-used function for everyday spreadsheet work. It quickly gives you the total number of values within a specific range of cells. Whereas the COUNT function only counts cells containing numbers, the COUNTA function counts how many cells in the dataset contain any kind of data.
SimpleSheets
simplesheets.co › blog › how-to-count-cells-with-text-in-google-sheets
How to Count Cells with Text in Google Sheets: COUNTIF Guide
Use this table to find the right Google Sheets count formula for what you actually need. COUNTIF is the function that answers the question directly. It counts only the cells that meet a criterion, and the asterisk wildcard is a criterion that means "any run of text characters". Numbers and truly blank cells do not match it, so they drop out of the count automatically. ... Numbers, dates and empty cells are excluded, which is exactly what makes this different from COUNTA.
Top answer 1 of 3
1
You can also try:
=COUNTA(FILTER(B:G,A:A="Smith"))
2 of 3
0
The COUNTA Function is categorized under Excel Statistical functions. It will calculate the number of cells that are not blank within a given set of values. The COUNTA function is also commonly referred to as the Excel COUNTIF Not Blank formula.
The COUNTA function is useful if we wish to keep a count of cells in a given range. Apart from crunching numbers, we often need to count cells with values. In such a scenario, the function can be useful.
The Bricks
thebricks.com › home › resources › how to use counta in google sheets: a step-by-step guide
How to Use COUNTA in Google Sheets: A Step-by-Step Guide
April 22, 2025 - The Solution: If you truly only want to count cells with visible text or numbers and exclude these empty strings, you can use COUNTIF instead. The formula =COUNTIF(range, "<>") tells Google Sheets to only count cells whose content is "not equal ...
FormulasHQ
formulashq.com › home › blog › counta: google sheet formulas explained
CountA: Google Sheet Formulas Explained — FormulasHQ
January 29, 2024 - With its ability to count all non-empty cells, regardless of their content, the COUNTA function offers a level of flexibility and power that can greatly enhance your spreadsheet operations. ... Skip the manual steps — generate this in seconds with Google Sheets Formulas.Try Google Sheets Formulas ... A formula nerd with a passion for numbers and equations. Writes about Excel, Google Sheets, VBA, regex, and Salesforce formulas — for people who spend their day in spreadsheets.
GeeksforGeeks
geeksforgeeks.org › how-to-use-the-counta-function-in-google-sheets
How to Use the COUNTA Function in Google Sheets - GeeksforGeeks
January 14, 2026 - The COUNTA function can count any non-empty cell - including text, numbers, booleans like TRUE/FALSE, or symbols. Here's how to use it: Launch your Google Sheets document or open a new sheet where your data is stored.
Got It AI
got-it.ai › all articles › counta
COUNTA Articles: Excel and Google Sheets
The Google Sheets COUNTA function counts the total number of values within a range. In this tutorial, you will learn how to use the COUNTA... ... When you enter data in Excel, you sometimes do it with a lot of cells left blank to fill them at a later stage when data is available.
Statology
statology.org › home › how to use counta if in google sheets
How to Use COUNTA IF in Google Sheets
December 5, 2023 - Often you may want to use the COUNTA function with an IF function in Google Sheets to count the number of cells that are not empty only if a cell in a corresponding column meets a certain requirement.
Google Sheets
sheetshelp.com › sheets help › statistical › counta function – google sheets
COUNTA Function - Google Sheets - Sheets Help
September 21, 2023 - The COUNTA function counts the non-blank cells in a specified range.
Got It AI
got-it.ai › solutions › excel-chat › excel-tutorial › counta › counta-google-sheets
How to Use the COUNTA Function in Google Sheets
December 21, 2018 - This formula counts the values from cells A2 to A8. Cells A2 to A8 have text values which can only be counted using the COUNTA Google Sheets function. This formula returns the number 7. COUNTA Google Sheets recognizes text, number, date, and other values but fails to calculate blank cells.
Sturppy
sturppy.com › formulas › counta-google-sheets-formula
COUNTA: Google Sheets Formulas Explained
May 25, 2023 - COUNTA is a built-in Google Sheets formula that counts the number of non-blank cells in a range of cells. It helps you determine the size of your dataset and eliminates the need for manual counting. COUNTA counts cells that contain text, numbers, logical values, and formulas.
Arab Psychology
scales.arabpsychology.com › home › stats › how to count cells with criteria in google sheets using counta if
How To Count Cells With Criteria In Google Sheets Using COUNTA IF
January 15, 2026 - COUNTA IF is a function in Google Sheets that allows you to count the number of cells in a given range that contain a certain value or meet a specific criteria. This function can be useful for tracking data and analyzing information in a spreadsheet.
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 cells with multiple criteria in Google Sheets or Excel, use the COUNTIFS function. This uses the same process as the COUNT function, but it allows you to add multiple conditions to your formula. IFS functions also allow you to choose cells that contain additional names, numbers, or characters. Google Sheets counting cells with text is easy once you know what you’re doing. In this case, you can use the COUNTA function to count cells with any text or the COUNTIF formula to count cells with specific text.
Published: September 9, 2025