Tips, tutorials, and training
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
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
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
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
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