Count With OR Logic in Google Sheets
Count cells based on several conditions
Count cells based on several conditions
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 based on values in two columns
Count cells that do not match a condition
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