try:
=INDEX(REGEXMATCH(A2:A&""; "\d+"))
Statology
statology.org › home › google sheets: a simple formula for “if contains”
Google Sheets: A Simple Formula for "If Contains"
March 31, 2025 - The IF() combined with REGEXMATCH() formula gives you a flexible way to check if cells contain specific text in Google Sheets.
Top answer 1 of 3
3
try:
=INDEX(REGEXMATCH(A2:A&""; "\d+"))
2 of 3
1
RegexMatch() will do that. Try-
=IF(RegExMatch(TEXT(A1,"@"),"[0-9]"),"Has Number","Text Only")
Google Sheets formula for "if contains" - Web Applications Stack Exchange
I'm trying to figure out how to identify IF a list of items in one cell containing a value or string. EXAMPLE Cell A1 contains sites, sheets, docs, slides. I want cell B1 to display a 1 'if' cell A1 More on webapps.stackexchange.com
Trying to use IF fuction to use formula if the Cell contains either certain text or numbers
Haven't accessed the file, but maybe you can try this out: =if(count(D79:G79)<4,"-",sumproduct(D79:G79,$J$9:$M$9)) This formula returns a dash if any of the cells in column D to G does not contain a valid number. More on reddit.com
8
2
January 7, 2023Google Sheets IF Statement with Numbers and 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
IF CONTAINS formula Google Sheets
I've been trying to use a formula similar to IF a cell CONTAINS this, then do this. Specifically, I want the formula to evaluate if the 'A' column… More on reddit.com
11
6
November 29, 202216:22
If Text Contains Word - Excel & Google Sheets - YouTube
01:41
Google Sheets - Count Cells Containing Specific Text - YouTube
03:05
Google Sheets - Count Cells with Text Only - Not Numbers - YouTube
03:06
Using the IF Function on Text in Google Sheets - YouTube
05:47
Google Sheets QUERY Function Tutorial - Advanced Contains with ...
03:52
IF CONTAINS in Google Sheets - YouTube
The Bricks
thebricks.com › home › resources › how to use isnumber in google sheets: a step-by-step guide
How to Use ISNUMBER in Google Sheets: A Step-by ... - Bricks
April 22, 2025 - ... Here, the value argument is simply the cell you want to check. For example, =ISNUMBER(A2) will check cell A2 and give you a TRUE or FALSE answer. It's important to understand what Google Sheets considers a "number":
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › a simple isnumber google sheets guide
A Simple ISNUMBER Google Sheets Guide for 2026 (10 Mins)
January 16, 2023 - This includes an operation and a number in quotes. Instead, you should use ISTEXT, which returns True if a value is a text string. ISNUMBER is a function that tells Google Sheets if a cell contains a number.
Top answer 1 of 11
199
You can use REGEXMATCH:
=IF(REGEXMATCH(A1, "sites"), 1, 0)
REGEXMATCH returns true if the first argument matches the regular expression given by the second argument. As long as the second argument has no regex special metacharacters (^ $ \ . * + ? ( ) [ ] { } |), this returns true if that argument is a substring of your string.
2 of 11
31
If you, as Ryan Shillington suggests, want to know the number of cells within a range that has "sites" in it, you might try:
=COUNTIF(A1:A100;"*sites*")
The * acts as a wildcard notion, so it will look for a match anywhere within the cell, not just an exact match for the whole cell.
I've also done this with a cell reference instead of "sites", but then you have to add wildcard-asterixes to the text in the cell.
Google Support
support.google.com › docs › answer › 3093296
ISNUMBER - Google Docs Editors Help
*ISNUMBER returns TRUE if this is a number or a reference to a cell containing a numeric value and FALSE otherwise.
Reddit
reddit.com › r/googlesheets › trying to use if fuction to use formula if the cell contains either certain text or numbers
r/googlesheets on Reddit: Trying to use IF fuction to use formula if the Cell contains either certain text or numbers
January 7, 2023 -
So i have a google sheet that keeps a score system of every book if read. And right now i use =sumproduct(D79:G79,$J$9:$M$9) in ROW H to total an overall score based on 4 weighted categories (The $J$9:$M$9 is the weights) however i added a long list of books that havent read and because the cells are empty the formula automatically makes it a 0 which brings down my overall average score on my sheet (yes this is important to me because it bugs me)
So essentially what i want to do is either make a formula that IF the cell contains "-" than Row H will also have a "-" while still keeping my original sumproduct formula in someway
or that if the cell has a number using ISNUMBER it uses the sumproduct formula.
Example table
| Formula | Story | Writing | Characters | Length | Overall |
|---|---|---|---|---|---|
| =sumproduct(D79:G79,$J$9:$M$9) | 1 | 1 | 1 | 1 | this formula gives a 1 |
| =sumproduct(D79:G79,$J$9:$M$9) | - | - | - | - | This formula with the dashes gives a 0 |
| What i would like the formula to do | - | - | - | - | - or N/A |
I don't know if the table helps
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › if contains google sheets: search + regexmatch
If Cell Contains Text in Google Sheets, Here Are the Fastest Formulas That Actually Work
Searching a massive spreadsheet for specific text can be annoying when you do it manually. There isn’t an exact IF CONTAINS Google Sheets function.
Published: January 9, 2026
Dokin
dokin.co › blog-posts › if-contains-in-google-sheets---easy
IF CONTAINS in Google Sheets - Easy! - Dokin
January 19, 2024 - This combination gives you the power of an SQL IF CONTAINS function within Google Sheets. ... Now that we know to use the combination of IF and REGEXMATCH it’s easy to do many things with it.For example if we wanted to count the number of cells which have a specific text (e.g.
Automate Excel
automateexcel.com › home › check if cell contains any number – excel & google sheets
Check if Cell Contains Any Number – Excel & Google Sheets - Automate Excel
February 8, 2023 - To check if a cell contains a specific number, we can use the FIND or SEARCH Function. ... In this example we use the FIND Function to check for the number 5 in column B. It returns the position of the number 5 in the cell if it is found and ...
Modernschoolbus
modernschoolbus.com › home › how to use the isnumber function in google sheets
How to Use the ISNUMBER Function in Google Sheets
One of the most common ways the ISNUMBER function is used is in combination with the IF function. By nesting together these two functions you can create a formula that will check to see if a cell contains a number, and then if it is, you can ...
FormulasHQ
formulashq.com › home › blog › isnumber: google sheet formulas explained
IsNumber: Google Sheet Formulas Explained — FormulasHQ
January 29, 2024 - The formula might look something like this: =IF(ISNUMBER(A2), A2*2, "Error"). Like any formula in Google Sheets, the IsNumber function can sometimes return unexpected results or errors.
InfoInspired
infoinspired.com › home › google docs › spreadsheet › isnumber function: checking for numbers in google sheets
ISNUMBER Function: Checking for Numbers in Google Sheets
August 14, 2024 - =ISNUMBER(A$2) – Allows only numbers in A2:E2 and permits any value in A3:E10 only if the corresponding cell in row #2 (A2:E2) contains a number. =ISNUMBER($A$2) – Permits entry in the selected range only if the cell content in A2 is a number, or only after entering a number in A2. How to Split a Number into Digits in Google Sheets
Better Sheets
bettersheets.co › formulas › isnumber
ISNUMBER Google Sheets Formula: Checks whether a value is a number.
Checks whether a value is a number. ... In cells B1:B10, use the ISNUMBER formula to check if the corresponding values in A1:A10 are numbers.
Checksheet
checksheet.app › google-sheets-formulas › isnumber
ISNUMBER Google Sheets Formula | Check Sheet
The ISNUMBER formula is used to check if a given value is a number. It returns TRUE if the value is a number and FALSE if it is not. This formula is commonly used in data cleaning and validation to identify and remove non-numeric values or to ...
Sturppy
sturppy.com › formulas › isnumber-google-sheets-formula
ISNUMBER: Google Sheets Formulas Explained
May 30, 2023 - In simple terms, ISNUMBER is a function in Google Sheets that checks whether a value is a number or not. It returns true if the cell contains a number, and false if it does not.
Google Support
support.google.com › docs › thread › 120398679 › google-sheets-if-statement-with-numbers-and-text
Google Sheets IF Statement with Numbers and Text - Google Docs Editors Community
August 8, 2021 - 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
Arab Psychology
scales.arabpsychology.com › home › how to use the “if contains” formula in google sheets
How To Use The "If Contains" Formula In Google Sheets
December 5, 2025 - This formula will return a 1 if the cell A2 contains the string “Lakers” or the string “Mavericks,” and a 0 otherwise. Notice how this single pattern handles the complexity that would otherwise require nested spreadsheet functions. While IF and REGEXMATCH are excellent for column-level checks, advanced users often look for solutions that can process entire ranges or filter data dynamically. Google Sheets offers powerful alternatives that integrate containment logic directly into filtering or querying operations.
FormulasHQ
formulashq.com › home › blog › how to do an if contains statement in google sheets?
How to do an if contains statement in Google Sheets? — FormulasHQ
October 9, 2024 - Google Sheets is a powerful tool for organizing and analyzing data. One of its key features is the ability to use logical statements to perform calculations and make decisions based on specific conditions. In this article, we will focus on the "if contains" statement in Google Sheets, which allows you to check if a cell contains a specific value or substring.
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 - Returns TRUE if A1 contains a number, FALSE otherwise. Formulas unique to Google Sheets, like translation and stock data.