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.
Reddit
reddit.com › r/googlesheets › using countif to determine a specific text result
r/googlesheets on Reddit: Using countif to determine a specific text result
June 13, 2024 -
Im stuck at one point. I'm trying to use countif formula to determine how many times a word of a string of words appear but sometimes there are two entries in a single cell and I have separated them by a slash. The countif formula doesn't seem to capture it. I'll show an example attached to this.
Avenger Iron Man comes two times and Avenger Iron Man Red comes two times but somehow the countif doesn't capture the word after the slash.
(for your information this is just a basic example. My actual spreadsheet is massive and has a lot of entries separated by slash. 99 percent of the time I can filter by using a unique word. But when similar words come then it just fails). Any help would be appreciated.
Top answer 1 of 5
2
You should use =COUNTIF(B37:B39, "*Avenger*Iron Man Red*") in order to get a match for the "Avenger Iron Man Red" since that exact phrase isn't part of those three test lines.
2 of 5
2
The function in your screenshot is counting correctly as the list has 3 cells with the phrase “Avenger Iron Man”. What was the desired result from this function?
Countif for partial/similar text - 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
Using countif to determine a specific text result
You should use =COUNTIF(B37:B39, "*Avenger*Iron Man Red*") in order to get a match for the "Avenger Iron Man Red" since that exact phrase isn't part of those three test lines. More on reddit.com
9
0
June 13, 2024How to count cells with any text in them.
Counta should do the trick
More on reddit.com 6
1
August 2, 2022COUNTIF - Ignoring formulas that return blank cells
This formula will work and not count the formulas in blank cells. =SUM(IF(C1:C14<>"", 1, 0)) replace the C1:C14 with your array. More on reddit.com
5
1
November 26, 2024Does 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
🧮 Count Cells Containing Specific Text (Google Sheets) - YouTube
01:49
How Count Cells With Specific Text in Google Sheets - YouTube
02:00
Google Sheets: how to count cells with specific text! - YouTube
15:42
COUNT, COUNTIF, COUNTIFS functions in Google Sheets - YouTube
01:13
How To Count Specific Words In Google Sheets - YouTube
16:22
If Text Contains Word - Excel & Google Sheets - YouTube
Excel Insider
excelinsider.com › home › our blog › google sheets functions › how to count cells that contain partial text in google sheets
How to Count Cells That Contain Partial Text in Google Sheets - Excel Insider
June 26, 2025 - Count Cells That Contain Partial Text in Google Sheets [Make a Copy] Use =COUNTIF(range, “*word*”) to count cells containing a specific word anywhere in the text.
Coefficient
coefficient.io › home
How to Use The COUNTIF Google Sheets Function - Coefficient
September 2, 2025 - For this example, type: Count C3 to C18 and see if they contain the word “website”. Then press ‘Build’. Formula Builder will automatically generate the formula from the first example.
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
Let’s look at an example to help you understand better. Click on an empty cell and input the function: =SUMPRODUCT( Type “LEN” after the opening bracket and select it from the formula suggestions. Select the range you want to count. Close the bracket and add >0. This formula will return the number of cells with text. To count a cell containing text in Google Sheets, you can use the COUNTIF function.
Published: September 9, 2025
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 COUNTIFS, which counts a row only when every range and criteria pair is true. For example =COUNTIFS(A2:A10, "Apple", B2:B10, "Fruit"). Every range in a COUNTIFS must span the same number of rows, otherwise Google Sheets returns an error.
Layer
golayer.io › home › countif & countifs in google sheets: formula & examples
COUNTIF & COUNTIFS in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - When sharing a Google Sheets spreadsheet, Google typically shares the entire document. Here’s how to share only one tab instead. ... Second, let’s find the number of sales made by ‘Southteam’. Instead of using an exact match, you can use wildcards to search for part of the text. ... 3. For the criterion, the function should match cells containing ‘south’, followed by any number of characters. COUNTIF & COUNTIFS in Google Sheets: Formula & Examples – Add COUNTIF Criterion
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
Coupler.io Blog
blog.coupler.io › home › when to use countif or countifs in google sheets: real-life formula examples
COUNTIF vs. COUNTIFS in Google Sheets | Coupler.io Blog
August 5, 2025 - For example, you want to count the values in the F column of the All orders sheet (data_range) that contain exact “Mark Oliver” (criterion#1) and the values that contain “Olivia Jensen” (criterion#2). You might have thought about the ...
Rows
rows.com › blog › post › countif-formula-in-google-sheets
How to Use the COUNTIF Google Sheets Function in 2025
August 19, 2024 - ... For partial string matches, can you use wildcards like * (any number of characters)? (single character). Example: =COUNTIF(A1:A10, "*apple*") will count cells containing "apple" anywhere in the text.
Excel Insider
excelinsider.com › home › our blog › google sheets functions › google sheets countif to check if a cell contains text
Google Sheets COUNTIF to Check If a Cell Contains Text - Excel Insider
August 1, 2025 - Use =COUNTIF(range, “*”) to count only cells containing text. This excludes blank cells and numbers but includes all text entries, even partial words or phrases. COUNTIF alone can’t handle multiple exclusions, but using helper columns ...
Statology
statology.org › home › how to use countif contains in google sheets
How to Use COUNTIF Contains in Google Sheets
October 7, 2022 - From the output we can see that 2 rows contain “Mav” in the Team column and “Guar” in the Position column. The following tutorials explain how to perform other common operations in Google Sheets: Google Sheets: COUNTIF Greater Than Zero Google Sheets: How to Use COUNTIF with OR Google Sheets: How to Use COUNTIF From Another Sheet
Productivity Spot
productivityspot.com › home › spreadsheets › a smooth step-by-step countif google sheets guide
A Step-By-Step COUNTIF Google Sheets Guide for 2026 | PS
January 4, 2024 - You can also use wildcard characters in case of text criterion. For example, to count cells that contain Apple or Apples, you can use Apple* as the criterion. The COUNTIF function Google Sheets is used to count the number of times a criterion has been met in a range of cells.
3Pie Analytics
3pieanalytics.com › excel-and-google-sheets-formulas-and-example › count-if-cells-contain-a-specific-text-in-excel-or-google-sheets
count if cells contain a specific text in Excel and Google Sheets
=COUNTIF(A2:A7,"*apple*") // criteria within formula · =COUNTIF(A:A,"*"&C6&"*") // criteria as a cell reference ... Wildcard: The * character allows for any number (including zero) of other characters to take its place.
Got It AI
got-it.ai › solutions › excel-chat › excel-tutorial › countif › how-to-use-a-countif-function-in-google-spreadsheets
Learn How to Use COUNTIF Function in Google Sheets - Excelchat
February 13, 2023 - Select the range of cells which you want to text again your criterion ... Finally, press the ENTER key on the keyboard to enter the closing bracket. Suppose we have sales dataset of some inventory items and we want to use COUNTIF function in Google Sheets to perform the following calculation on this data set. Now we want to test the sales range of B2:B9 again this criterion expression of “>400”. As data range contains numeric values, so we will place the express in double quotation marks, as shown below
Usemage
usemage.com › google-sheets-how-to › how-to-count-cells-containing-specific-text-in-google-sheets
How To Count Cells Containing Specific Text In Google Sheets - Google Sheets Help | Mage - AI for Google Sheets
This function allows you to count ... with the following syntax: =COUNTIF(range, criteria). For example, to count cells in the range A1:A10 that contain the word 'apple', use =COUNTIF(A1:A10, "apple")....
Google Support
support.google.com › docs › thread › 203666768 › countif-for-partial-similar-text
Countif for partial/similar text - Google Docs Editors Community
February 25, 2023 - 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
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 - We can use COUNTIF to count cells with a specific text in Google Sheets which, in this case, is “American.” To do this, simply type in the following formula: =COUNTIF(B1:B8, “American”) – where B1:B8 is the range of data you’re looking ...
Simplify Sheets
simplifysheets.com › home › blog › count cells containing specific text with google sheets
Count Cells Containing Text & Filter In Google Sheets - Simplify Sheets
March 15, 2023 - If we make a reference to cell A2 which contains the state’s name we will be able to use the autofill feature rather than writing out each state’s name. We will need to put the * in quotations and we will use & to combine all the information. The & operation works in a similar way as the CONCATENATE function. =COUNTIF('Data Source'!B:B,CONCATENATE("*",A2,"*"))
Softr
softr.io › home › blog › 100 google sheets formulas that actually work: a cheat sheet
100 Google Sheets formulas: The complete list
July 23, 2026 - COUNTIF (Math): Counts how many cells in a range satisfy a single condition, whether that's an exact match, a text string, or a comparison. REGEXMATCH (Text): Checks whether a text string contains a pattern described by a regular expression, returning TRUE or FALSE rather than the match itself.