Formulas Archives - Page 14 of 25

How to VLOOKUP from Another Sheet in Google Sheets (2 Ways)

August 10, 2023 Formulas

VLOOKUP is a vertical lookup that we use when we need to find a value row-wise within columns in a table. For example, we can use VLOOKUP to look up ...

How to VLOOKUP from Another Sheet in Google Sheets (2 Ways)

How to VLOOKUP with Multiple Criteria in Google Sheets

August 10, 2023 Formulas

We are familiar with using VLOOKUP with single criteria but sometimes we need to do it with multiple criteria. There are many ways to VLOOKUP with ...

How to VLOOKUP with Multiple Criteria in Google Sheets

How to Use VLOOKUP to Import from Another Workbook in Google Sheets

August 3, 2023 Formulas

When working with a large volume of data it can be tiring and time-consuming to go back and forth to look for specific data. In that case, Google ...

How to Use VLOOKUP to Import from Another Workbook in Google Sheets

Google Sheets: Sum if Cell is Not Blank

October 31, 2022 Basics

In this tutorial, we will look at how to sum if a cell is not blank in Google Sheets over a range of cells. The Basic Way to Sum if a Cell is Not ...

How to Sum Cells from Different Sheets in Google Sheets (3 Easy Ways)

October 30, 2022 Basics

In this simple tutorial, we will look at a few ways we can use to sum cells across different sheets in Google Sheets. While the idea is simple, ...

How to Sum Cells from Different Sheets in Google Sheets (3 Easy Ways)

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

October 27, 2022 Basics

In this simple tutorial, we will look at a few scenarios where we sum values in Google Sheets if there are multiple conditions. The Core of the ...

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

Find the Sum of Cells with Specific Text in Google Sheets

October 26, 2022 Basics

In this simple tutorial, we will look at a few ways to find the sum of cells with specific text in Google Sheets. While it sounds simple, there ...

Google Sheets: Sum an Entire Column (4 Easy Ways)

October 24, 2022 Basics

Adding or summing values in a spreadsheet is a common process. And with such a versatile application like Google Sheets, we have so many ways we can ...

Google Sheets: Sum an Entire Column (4 Easy Ways)

Format Cell as Text in Google Sheets (3 Simple Scenarios)

October 23, 2022 Basics

In this article, we will look at a few scenarios to format a cell as text in Google Sheets. There are many reasons why we’d want to do that, of ...

Format Cell as Text in Google Sheets (3 Simple Scenarios)

Google Sheets: Sum of Cells with Text (4 Examples)

October 19, 2022 Basics

In this simple tutorial, we will look at a few example scenarios where we sum cells with text or those that depend on text in Google Sheets. Note ...

Google Sheets: Sum of Cells with Text (4 Examples)

Google Sheets: If Cell Color is Red Then Take Action

October 18, 2022 Basics

In this article, we will look at a few ways to work with the condition "if cell color is red the take action" in Google Sheets. With conditional ...

Google Sheets: If Cell Color is Red Then Take Action

How to Split a Cell in Google Sheets (9 Quick Methods)

January 22, 2023 Formulas

We often require to split appended values from a cell. For example, we may want to separate URLs and email extensions or extract known values from a ...