Formulas

Compare Two Columns for Duplicates in Google Sheets (3 Easy Ways)

Today we will look at a few ways to compare two columns for duplicates in Google Sheets. While the idea is simple, we can have multiple scenarios ...

Using Conditional Format to Compare Two Columns in Google Sheets

Today we are going to specifically look at how to compare two columns using conditional formatting in Google Sheets. Let’s get started. 2 ...

How to Format Date in Google Sheets (3 Easy Ways)

Working with dates is one of the more common tasks available for any spreadsheet user. However, many users of varying expertise still have certain ...

How to Add Months to a Date in Google Sheets (2 Easy Ways)

Working with dates is one of the core tasks that anyone does in a spreadsheet. And today, we will look specifically at how we can add months to a ...

Count Days From Today in Google Sheets (5 Easy Ways)

Counting between dates is a common task for any spreadsheet user as dates tend to be one of the most important forms of data in any spreadsheet. ...

Find and Display Current Date in Google Sheets (Easy Guide)

The Date and time are one of the more fundamental aspects of any professional report. Understanding that, finding and displaying the current date and ...

Google Sheets: Sum If Checked (2 Ways)

Adding values under certain conditions is a common affair in Google Sheets. But one approach that can be used to simplify a condition is the ...

Applying SUMIF from Another Sheet in Google Sheets

SUMIF is one of the fundamental functions of Google Sheets which also means that its application might vary. As such, today we will look at how we ...

How to Perform Conditional Sum in Google Sheets (Easy Guide)

To perform conditional sum in Google Sheets is relatively easy. The primary approach is to combine the idea of the SUM and IF functions of the ...

How to Sum Multiple Rows in Google Sheets (3 Ways)

Today we will look at how to sum multiple rows in Google Sheets. While one method is expectedly common, the others may prove to help in some dynamic ...

Match Multiple Values in Google Sheets (An Easy Guide)

At a professional level, spreadsheet searches can get quite complex with the amount of varying data they might have. Thus, we have to look for viable ...

Match from Multiple Columns in Google Sheets (2 Ways)

Today, we will look at how to perform a match from multiple columns in Google Sheets. This process is useful if you want to extract values based on ...

INDEX-MATCH with Multiple Criteria in Google Sheets (Easy Guide)

We are already aware of how powerful the INDEX-MATCH combination is when extracting data in Google Sheets. If not, please visit our Using INDEX MATCH ...

How to Use Conditional Formatting in Google Sheets

Today we will have a look at how to use conditional formatting in Google Sheets, which is potentially one of the most used built-in functions by any ...

Google Sheets: Conditional Formatting with Multiple Conditions

When we think about multiple conditions, the first thing that comes to mind is its logical formatting. So it comes to no surprise that when creating ...

OfficeWheel
Logo