How to Easily Count Cells with Text in Google Sheets: 3 Simple Methods

To efficiently count cells containing text within Google Sheets, you can employ various functions tailored to different levels of specificity. The following three foundational methods cover the most common counting scenarios:

Method 1: Count Cells with Any Text (Non-Empty)

=COUNTA(A1:A10)

Method 2: Count Cells with Specific Text (Single Criterion)

=COUNTIF(A1:A10, "Text")

Method 3: Count Cells with One of Specific Texts (Multiple OR Criteria)

=ArrayFormula(SUM(COUNTIF(A:A,{"Text1", "Text2"})))

We will utilize the following sample dataset to illustrate the practical application of each method throughout the rest of this guide:

Understanding Text Counting and Non-Empty Cells

When working with spreadsheets, it is vital to distinguish between cells containing numerical values, formulas that return numbers, and cells containing actual text strings. Many standard counting functions, such as COUNT, specifically ignore non-numerical data. Therefore, to count cells that contain any form of data—including text, dates, times, or Boolean values—we rely on specialized functions like COUNTA.

The core concept of “counting cells with text” often expands to include counting all non-empty cells, as text is a subset of non-empty data. The COUNTA function is designed precisely for this purpose. It tallies every cell within a designated range that is not truly blank. This is particularly useful when you need a quick measure of record density or when determining the total number of entries in a column, regardless of the data type. Understanding this generalized approach is the first step toward advanced conditional counting.

Furthermore, conditional counting methods, such as those employing COUNTIF, allow us to filter the non-empty cells based on their textual content. For instance, if a cell contains the text “Complete” or “Pending,” we can selectively count only those matching a specific criteria. This level of filtering moves beyond simply detecting presence and enters the realm of qualitative data analysis, which is crucial for tracking statuses or categorizing items in a large dataset.

Method 1: Counting Cells with Any Text using COUNTA

The COUNTA function stands for “Count All,” signifying its role in counting every cell within a range that contains any value whatsoever. This includes not only text strings but also numbers, dates, error values (like #N/A), and cells containing formulas that return an empty string ("")—although the latter is a common point of confusion. For the purpose of counting non-blank cells that hold textual data, COUNTA provides the simplest and most direct solution.

The syntax for COUNTA is straightforward: =COUNTA(value1, [value2, ...]). Typically, you will input a single range reference, such as A2:A12, as the first argument. The function then iterates through every cell in that specified range and increments the count for each cell it finds populated. It is important to remember that if a cell is truly empty—meaning it contains absolutely no data or formula—it will not be counted. This function is often employed when quickly assessing the volume of records in a spreadsheet column.

While COUNTA is highly effective for determining the overall volume of data, users must be mindful of its limitations. It does not differentiate between numerical data and text data. If your goal is strictly to count text while ignoring numbers, you might need a more complex solution, such as a combination of COUNTIF and a wildcard character, though for most general text counting needs, COUNTA is the go-to function.

Practical Demonstration: Counting Any Text

Using our provided dataset, we aim to determine the total number of cells in Column A that contain any data, which includes the textual entries. Our range of interest spans from A2 down to A12, covering all visible entries in the sample table.

We apply the simple COUNTA function to this specific range to execute the count:

=COUNTA(A2:A12)

The application of this formula within the sheet environment yields the following result, clearly illustrating how the function calculates the total number of non-empty cells:

Upon execution, we observe that the formula successfully identifies 8 cells containing any type of data—including text—within the specified range A2:A12. This confirms the efficacy of COUNTA for quickly assessing dataset density.

Method 2: Counting Cells with Specific Text using COUNTIF

The COUNTIF function is arguably the most fundamental tool for conditional counting in Google Sheets. Unlike COUNTA, which counts everything, COUNTIF allows you to specify a single criterion that a cell must meet to be included in the total count. This makes it invaluable for counting records based on specific status labels, categories, or keywords.

The structure of the COUNTIF function is straightforward: =COUNTIF(range, criterion). The range is the group of cells you wish to evaluate, and the criterion is the condition that determines which cells are counted. When counting specific text, the criterion must be enclosed in quotation marks (e.g., "Pending"). If the text criterion is stored in another cell, you can simply reference that cell (e.g., B1).

A key aspect of using COUNTIF for text counting is its ability to handle partial matches using wildcard characters. For instance, to count all cells that merely *contain* the word “Apple” anywhere in the string, you would use the criterion "*Apple*". The asterisk (*) acts as a placeholder for any sequence of characters. This technique is extremely powerful for inexact matching and pattern detection within large bodies of text data.

Practical Demonstration: Counting Specific Text

Now, let us refine our count to identify only those cells in Column A that contain the specific text string “A”. This is a precise match requirement, excluding any cells containing variations like “A1” or “AB”.

We employ the COUNTIF function, defining the range (A2:A12) and setting the criterion to the exact text “A”:

=COUNTIF(A2:A12, "A")

The resulting screenshot below demonstrates the computation. The function meticulously checks each cell in the range against the defined criterion, returning a total count of matching instances:

By examining the dataset, we can confirm that there are exactly 2 rows that contain the precise text “A” in column A, verifying the accuracy of the COUNTIF function in this focused scenario.

Advanced Technique: Counting Multiple Specific Texts (OR Logic)

When dealing with complex datasets, you often encounter situations where you need to count cells that match one of several possible text criteria—an ‘OR’ condition. For example, counting records labeled “A” OR “B” OR “C”. Standard COUNTIF only handles one criterion at a time, making it necessary to combine functions for this powerful capability. The most elegant and scalable method in Google Sheets involves combining ArrayFormula, SUM, and COUNTIF.

This sophisticated method works by passing an array (a list of criteria) into the COUNTIF function. When COUNTIF receives an array of criteria, it performs the count for each criterion individually, generating an array of results. For instance, if you ask it to count {“A”, “B”}, it returns an array like {2, 3}, meaning it found 2 instances of “A” and 3 instances of “B”.

To finalize the operation, the SUM function is wrapped around the criteria-array output to add up all the individual counts, providing the total count of all cells matching *any* of the specified criteria. Finally, the entire expression must be wrapped in ArrayFormula to enable the processing of the criteria array, instructing Google Sheets to treat the input and output as a range of values rather than a single calculation. This combination is highly efficient for managing extensive lists of criteria.

Practical Demonstration: Counting Multiple Specific Texts

For this advanced example, we will count all cells in Column A that contain either the text “A” or the text “B”. This requires the array-based approach to simultaneously evaluate both conditions and sum their respective results.

The complete formula utilizes COUNTIF with the criteria array {"A", "B"}, which is then summed and executed using the ArrayFormula wrapper. Note that we are using the entire column reference (A:A) for maximum scalability, although the data only occupies A2:A12 in this sample:

=ArrayFormula(SUM(COUNTIF(A:A,{"A", "B"})))

Observing the result in the sheet, the formula successfully tallies the instances of both “A” and “B” across the column:

The final calculation reveals that there are a total of 5 rows containing either the text “A” or “B” in column A. This demonstrates the robust capability of using array logic for handling multiple ‘OR’ text conditions simultaneously.

Method 4 (Bonus): Counting Text Based on Multiple Criteria using COUNTIFS (AND Logic)

While the ArrayFormula approach handles ‘OR’ logic (matching criterion X or criterion Y), many analytical tasks require ‘AND’ logic—counting cells in one range only if corresponding cells in *another* range also meet a certain condition. This is precisely the function of COUNTIFS. The ‘S’ denotes the ability to handle multiple criteria and ranges simultaneously.

The syntax for COUNTIFS is structured as =COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]). For example, if you wanted to count how many times “A” appeared in Column A, but only for rows where Column B contained the text “Complete”, you would use =COUNTIFS(A:A, "A", B:B, "Complete"). Every criterion must be met for a row to be counted.

This function is essential for segmentation and detailed filtering. It allows you to count specific textual records based on temporal constraints, departmental assignments, or secondary status indicators, thereby providing a much more nuanced view of your data compared to single-criterion counting. Mastering COUNTIFS ensures you can isolate specific text instances based on complex structural requirements within your spreadsheet.

Summary of Text Counting Techniques

Selecting the appropriate counting function in Google Sheets depends entirely on the complexity of the criteria you need to apply. For basic checks, COUNTA is the tool for identifying the volume of all non-empty records. When precision is needed for a single text value, COUNTIF provides reliable, fast results, especially when augmented by wildcard characters for partial matches.

For advanced filtering, the choice between ‘OR’ logic and ‘AND’ logic dictates the necessary structure. The combination of ArrayFormula(SUM(COUNTIF(…))) provides a robust solution for matching any item from a list of textual criteria within a single column. Conversely, the COUNTIFS function is the standard professional approach for cross-column verification, ensuring multiple conditions across different ranges are met before a record is tallied.

By systematically applying these primary methods—COUNTA, COUNTIF, and the ArrayFormula/COUNTIF structure—you gain comprehensive control over counting textual data in Google Sheets, moving beyond simple arithmetic to powerful conditional data analysis.