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 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

COUNT Function – Google Sheets

The COUNT function counts the numeric values in a data set. When all inputs to the function are numbers, it produces the same result as the COUNTA function. However, when the inputs are text or boolean values, the COUNTA function acts differently than COUNT. Get your copy of the template used in this tutorial to follow along. … Read more