Count With OR Logic in Google Sheets
Count cells based on several conditions
query
3 Google Sheets Formulas for No-Code App Builders
This tutorial focuses on three must-know Google Sheets functions for building a no-code app. No-code app builders may not be familiar with spreadsheets, just as spreadsheet users (gulp) may not know how to build an app. I had the pleasure of working with Darren Alderman, who makes Glide apps for Google Sheets. We collaborated on … Read more
Count Cells in Two Columns Using an OR Condition
Count cells based on values in two columns
Count Cells Without Certain Text Anywhere in the Cell
Count cells that do not match a condition
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