Count Cells Without Certain Text Anywhere in the Cell

There are many ways to count cells in Google Sheets conditionally. However, most techniques look for a positive match to a condition. Let’s explore the opposite, where we count cells that do not match a condition. Follow along with these examples using this live spreadsheet. First, we will be using COUNTIF, which is the most efficient method of conditional counting as … Read more

Count Cells That Don’t End With Certain Text – Google Sheets

There are several different ways to count cells in Google Sheets conditionally. However, most techniques look for a positive match to a condition. Let’s explore the opposite, where we count cells that do not match a condition. Follow along with these examples using this live spreadsheet. First, we will be using COUNTIF in the first example, which is the most efficient method … Read more

Count Cells Not Containing Certain Text – Google Sheets

There are several different ways to count cells in Google Sheets conditionally. However, most techniques look for a positive match to a condition. Let’s explore the opposite, where we count cells that do not match a condition. Follow along with these examples using this live spreadsheet. We will be using COUNTIF in these examples, which … Read more

COUNTIF Function – Google Sheets

The COUNTIF function is used in Google Sheets to count cells if data meets a specific condition. COUNTIF checks cells for a condition and then counts every cell in the range that meets it. Use the COUNTIFS function if you have more than one criteria. Get your copy of these examples in a live Google … Read more