Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to SUMIF cells if contains text in Google Sheets.
How to SUMIF Cells If Contains Text in Google Sheets
The SUMIF function in Google Sheets is a powerful tool for adding up cells based on certain criteria.
One criteria we can check for is whether a particular cell contains text or not.
In this guide, we will show you how to use the SUMIF function in Google Sheets to sum cells only if a corresponding cell in the same row contains text values.
How to Use SUMIF When Cells Contain Text in Google Sheets
Here’s our step-by-step guide on how to use sumif when cells contain text in Google Sheets.
First, select an empty cell to place the SUMIF function.
In our example above, we want to find the sum of all quantities in our table given that their status is not blank.
We’ll start by typing the SUMIF function.
We’ll select the range we’ll use to determine what gets added to the total.
In this example, we’ll choose the Status field since we only want to total quantities where the status field is not empty.
Next, we’ll add the string “<>” to indicate we want to check if our values are non-blank.
Finally, we’ll add our sum range as the third argument.
In this example, we’ll use the quantity field as our sum range.
Hit the Enter key to evaluate the SUMIF function.
In our example above, we’ve determined that we have a total order quantity of 31 where the order status is not blank.
This guide should be everything you need to learn how to SUMIF cells if they contain text in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Make a Numbered List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize