Count With OR Logic in Google Sheets
Count cells based on several conditions
Tutorials
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
Hide Data Using IMPORTRANGE in Google Sheets
Spreadsheets users often need to hide data from other users. Let’s say you have a file with employee pay details, and only personnel in the human resources department are allowed to see it. However, the accounting department needs to access summarized data. We will walk through a scenario where one user can see the detail … Read more
Count Cells Without Certain Text Anywhere in the Cell
Count cells that do not match a condition