(Updated Jan 2022 to reflect the increase in the cell limit of Google Sheets to 10 million.) Slow Google Sheets? We’ve all been there, stuck watching the little loading bar creep slowly, frustratingly to its conclusion: How can you speed up a slow Google Sheet? First off, this is a difficult question to answer because … Continue reading Slow Google Sheets? Here are 27 Ideas to Try Today ?
The IFS function in Google Sheets is used to test multiple conditions and outputs a value specified by the first test that evaluates to true. It’s akin to a nested IF formula, although it’s not exactly the same. However, if you find yourself creating a nested IF formula then it’s probably easier to use this … Continue reading IFS Function in Google Sheets
The INDIRECT function in Google Sheets is used to convert text strings into valid cell or range references. For example, the INDIRECT function will convert the text string “A1” into the cell reference A1. The formula is: =INDIRECT(“A1”) which is equivalent to this formula: = A1 It gives the answer 10 in the following example … Continue reading INDIRECT Function in Google Sheets
The IFERROR function in Google Sheets is a useful function to have in your Google Sheets toolbox. And it’s easy to learn. In this tutorial you’ll learn how it works and see common use cases. There are three principal uses for the IFERROR function: Replacing error values with a fallback value Catching errors and replacing … Continue reading IFERROR Function In Google Sheets
The SUBTOTAL function in Google Sheets is a powerful function for working with data. There are three principal uses for the SUBTOTAL function: Calculating Subtotals for lists of data Calculating metrics with filtered and/or hidden rows of data As a dynamic function selector It’s versatile, as you’ll see in this tutorial. However, it’s not well … Continue reading SUBTOTAL Function in Google Sheets