Sarah is a young professional making significant financial decisions. From credit cards to mortgages, student loans,...
How to find nominal interest rate using Google Sheets
read more
Google Sheets formulas articles
Pull Google Calendar data into Google Sheets using Apps Script
This post was originally published in our community forum. Objective : This guide demonstrates how to use Google Apps...
Using the PROPER function to capitalize the first letter of each word in Google Sheets
Note: This post was originally published in our community forum. Ever found yourself needing to clean up a list of...
Filter values in a column which are not in another column
Note: This post was originally published in our community forum. Hey everyone! 👋 Check out this handy formula for...
Get started with CLASP: Easy Google Apps Script setup
Note: This post was originally published in our community forum. Looking to supercharge your Google Apps Script...
Crafting dynamic 2D results in Google Sheets with MAP and LAMBDA functions
Note: This post was originally published in our community forum. Google Sheets offers a robust set of features that...
Mastering the IFs formula: simplify conditional logic in Google Sheets
The IFS formula in Google Sheets is ideal for evaluating multiple conditions in a single formula. Whether tracking...
Mastering ARRAYFORMULA: 4 use cases with examples
ARRAYFORMULA are valuable tools for managing spreadsheets, making it easier to handle complex calculations and...
Mastering the QUERY formula: 4 use cases with examples
The QUERY formula in Google Sheets is a powerful tool for filtering, grouping, and summarizing data. With this...
Top 5 formulas every process designer should know
Process design is like constructing a well-organized system—it’s all about using the right tools in the right places....
How to Highlight Duplicates in Google Sheets? (2026 Tutorial)
You are reading this post because you are probably tired of searching for duplicates in your Google Sheets. Finding...
How to add two numbers in Google Sheets: 3 different methods
There are an infinity of reasons to add two numbers in Google Sheets. In this article we’ll cover three different ways...
All Google Sheets IF functions
Google Sheet IF functions allow you to include condition-based formulas in your spreadsheets. Think of them like flow...
How to use SUMIF in Google Sheets
The SUMIF function in Google Sheets allows you to sum values in a range based on specific criteria. Whether you're...
How to use IFNA in Google Sheets to handle errors
IFNA in Google Sheets is a super simple function. It checks if a formula results in an error and returns a specific...
How to use COUNTIFS in Google Sheets
COUNTIFS is one of the many Google Sheets count functions. This formula works as its name suggests: it counts values...
How to use VLOOKUP with IMPORTRANGE in Google Sheets
Combining the power of VLOOKUP and IMPORTRANGE is a great way to transfer specific data between two spreadsheets....
How to filter IMPORTRANGE
There are many reasons to filter IMPORTRANGE results. You may want to share only some data and not an entire...
Is IMPORTRANGE not working? Learn how to fix it
In this article we will go over the most common IMPORTRANGE errors and how to fix them. Every error will be grouped...
SUMIFS with multiple criteria in Google Sheets
Learning to use Sumifs with multiple criteria is key for any Google Sheet user looking to analyze data. It enables you...
Countif greater than 0 Google Sheets
At its core, countif is super simple: it counts every cell that meets a condition. Countif greater than 0 is just one...
How to use VLOOKUP in Excel from another sheet or workbook
Learn how to use VLOOKUP in Excel from another sheet or workbook, step by step, plus how to look up data across several sheets with IFERROR.
How to VLOOKUP from another sheet or workbook in Google Sheets
Learn how to do a Google Sheets VLOOKUP from another sheet or workbook: pull data from another tab or a separate file, step by step, with screenshots.
How to use CONCATENATE in Google Sheets (complete guide + examples)
You can easily combine content from different cells with the CONCATENATE function. Here’s how to use CONCATENATE in Google Sheets.
Compound interest formula in Google Sheets (with examples)
Use the compound interest formula in Google Sheets to see how savings grow with annual, monthly, or daily compounding, then add monthly contributions.
Google Sheets FORECAST function (+ examples)
The Google Sheets FORECAST function predicts future values from past data. Build forecast sheets that project sales and expenses with step-by-step examples.
Z-score formula: How to find the Z-score
Learn the z score formula, how to calculate z-scores by hand and in Google Sheets with AVERAGE and STDEV, and how to interpret the results.
How to use INDEX MATCH with multiple criteria in Google Sheets
Set up Google Sheets INDEX MATCH multiple criteria lookups step by step, with vertical, horizontal, and mixed criteria plus an AVERAGE example.
How to subtract in Google Sheets: formula and examples
Subtracting in Google Sheets is easy and can be done quickly with the right formula. Here’s how to subtract in Google Sheets and simplify your data analysis.
REGEXMATCH in Google Sheets: how-to & examples
Learn the REGEXMATCH Google Sheets syntax and the special characters for regular expressions, then follow examples that match words, numbers, and sentences.
English 
Español 
Português do Brasil 
Français