To simply count all cells that contain the word Support, use this:
=countif(A2:F, "*Support*")
...where A2:F refers to the location of the "grid."
Cheers --Hyde Answer from --Hyde on support.google.com
Google Support
support.google.com › docs › answer › 3093480
COUNTIF - Google Docs Editors Help
COUNTIFS: Returns the count of a range depending on multiple criteria. SUMIF: Returns a conditional sum across a range. DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.
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, 2022Count selections from Drop-Down Menu
Use the Countif function =Coundif([enter range here], [enter drop down item in parentheses here]) More on reddit.com
11
1
February 7, 2023How to use wildcard asterisk INSIDE a COUNTIF function?
you're very close! =COUNTIF($D$2:$H$17,"*"&I3&"*") More on reddit.com
6
1
May 31, 2023🧮 Count Cells Containing Specific Text (Google Sheets) - YouTube
How Count Cells With Specific Text in Google Sheets
02:56
Google Sheets Count Cells with Text - YouTube
03:03
Google Sheets: Count Cells Containing Specific Text (2025 Tutorial) ...
02:00
Google Sheets: how to count cells with specific text! - YouTube
01:10
How To Count Cells with Specific Text in Google Sheets | count ...
Top answer 1 of 7
138
It will likely have been solved by now, but I ran accross this and figured to give my input
=COUNTIF(a2:a51;"*iPad*")
The important thing is that separating parameters in google docs is using a ; and not a ,
2 of 7
94
In case someone is still looking for the answer, this worked for me:
=COUNTIF(A2:A51, "*" & B1 & "*")
B1 containing the iPad string.
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?
SimpleSheets
simplesheets.co › blog › how-to-count-cells-with-text-in-google-sheets
How to Count Cells with Text in Google Sheets: COUNTIF Guide
To count cells that literally contain a question mark, use =COUNTIF(A2:A10,"*~?*"). Without the tilde, the question mark is read as "any single character" and your count balloons.
Rows
rows.com › blog › post › countif-formula-in-google-sheets
How to Use the COUNTIF Google Sheets Function in 2025
August 19, 2024 - The COUNTIF function in Google Sheets is useful for counting cells that meet a specific criterion. It returns a conditional count across a range. ... If the range contains text to check against, the criterion must be a string. Criterion can ...
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 - Then check out this video about COUNT, COUNTIF, and COUNTIFS functions in Google Sheets by Railsware. The COUNTIF function is a hybrid of COUNT and IF functions. It allows you to perform data counts based on a specific criterion.
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(A:A,"*"&C6&"*") // criteria as a cell reference ... Wildcard: The * character allows for any number (including zero) of other characters to take its place. 💡 In this example, it’s used to find all cells that include the text "apple".
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.
LiveFlow
liveflow.com › product-guides › how-to-use-countif-function-in-google-sheets
How to Use COUNTIF Function in Google Sheets | LiveFlow
Type “=COUNTIF(” or go to “Insert” in the menu bar ➝ “Function” ➝ ”Math” ➝ ”COUNTIF”. ... Select a set of data in which you want to find the number of cells that match a particular condition.
W3Schools
w3schools.com › googlesheets › google_sheets_countifs.php
Google Sheets COUNTIFS Function
GS Sort GS Sort Sheet GS Sort By ... function is a premade function in Google Sheets, which counts cells in a range based on one or more true or false condition....
Excel University
excel-university.com › home › blog › how to count cells that contain specific text
How to Count Cells That Contain Specific Text - Excel University
November 22, 2022 - Note: COUNTIF evaluates one condition; if you need to count cells based on multiple conditions use COUNTIFS instead. You’ll notice that this counts the cells that match apple. It does not count the number of times the word apple appears. In other words, a cell must only contain the word apple to be included in the count.
Better Sheets
bettersheets.co › formulas › countif
COUNTIF Google Sheets Formula: Count Cells That Match · Better Sheets
COUNTIF in Google Sheets counts cells that meet one condition. Syntax, examples, and video tutorials for criteria like text, numbers, and wildcards.
Arab Psychology
scales.arabpsychology.com › home › how can i use countif to check if a cell in google sheets contains a specific value?”
How Can I Use COUNTIF To Check If A Cell In Google Sheets Contains A Specific Value?"
June 26, 2024 - COUNTIF is a function in Google Sheets that allows users to count the number of cells within a specified range that meet a certain criteria. By using this function, it is possible to check if a cell contains a specific value by setting the criteria ...
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 containing text in Google Sheets, you can use the COUNTIF function.
Published: September 9, 2025
Exceljet
exceljet.net › home › formulas › count cells that contain specific text
Count cells that contain specific text - Excel formula | Exceljet
August 17, 2022 - To count cells in a range that contain text values, you can use the COUNTIF function and the asterisk (*) wildcard. In the example shown, the formula in cell H5 is: =COUNTIF(data,"*") where data is the named range B5:B15.
IONOS
ionos.com › digital guide › online marketing › online sales › countif in google sheets
COUNTIF in Google Sheets: how to use the function in Google’s spreadsheet program
November 13, 2020 - Example Google Sheet with COUNTIF function in cell Close · Let’s assume you want to view the number of invoices that contain a lower amount than 6,000. Select an empty cell to enter the formula and specify the range of cells (cell numbers) you want to begin the count from.
Sheetai
sheetai.app › blog › how-to-use-countif-in-google-sheets
How to Use COUNTIF in Google Sheets: A Comprehensive Guide
July 27, 2024 - Google Sheets will count the number of cells in the specified range that have sales greater than $500. If you have a list of responses and you want to count how many times a specific response appears, you can use COUNTIF.
Medium
medium.com › p › 1a119ec8a6b7
How to Use Google Sheet: CountIF. CountIF is a useful function in… | by Peppubooks | Medium
April 7, 2023 - Type the following formula: =COUNTIF(A1:B11, "Sales") ... This formula will count the number of cells in the range A1:B11 that contain the text string “Sales”.
3Pie Analytics
3pieanalytics.com › excel-and-google-sheets-formulas-and-example › count-if-cells-start-with-specific-text-in-excel-or-google-sheets
count if cells start with specific text in Excel and Google Sheets
=COUNTIF(A:A,C6&"*") // criteria as a cell reference · A2:A6 = data range · "feb*" = criteria and must start with feb (non-case sensitive) * asterisk explanation · a* = "a" at start · *b = "b" at end · How to count if cells start with specific text in Google Sheets?