Tips, tutorials, and training
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 that do not match a condition
This tutorial shows you two methods to display your dates as the month’s name in your spreadsheet. The default is to show the month, day, and year together. Therefore, you will have to make a few changes depending on the type of output you want. Grab a copy of this live sheet to follow along … Read more
Spreadsheets often have dates as part of their data. This tutorial will help you determine how many of these dates are between two days. Grab a copy of the live spreadsheet to follow along. Video Tutorial See the same examples explained in a video. Example 1 – Between Two Dates Let’s see how many days … Read more
There are several data types in Google Sheets. The more common types are numbers and text. There are also boolean values which are true or false, errors, arrays, and others. If you are unsure what type of data is in a cell, the TYPE function will identify it for you. To see live examples of … Read more