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