Excel Functions Archives - Page 2 of 29

Using the VLOOKUP Functions Between Worksheets in Excel

Jul 12, 2024

VLOOKUP Between Worksheets in Excel: Knowledge Hub VLOOKUP and SUM Across Multiple Sheets VLOOKUP Example Between Two Sheets Perform ...

Using the VLOOKUP Functions Between Worksheets in Excel

How to Use SUMIF to SUM Less Than 0 in Excel

Jun 9, 2024

The dataset represents the profit margin data of a super shop for 2021 and 2022 in Florida and Georgia. Method 1 - Using the ...

How to Use SUMIF to SUM Less Than 0 in Excel

How to Use Excel SUMIF with Greater Than Criterion: 6 Methods

May 27, 2024

Method 1 - Excel SUMIF Greater Than Specific Value Select cell D20, apply the formula below, and press Enter. =SUMIF(C5:C17,">2") ...

How to Use Excel SUMIF with Greater Than Criterion: 6 Methods

How to Use Excel SUMIF Function Based on Cell Color

Apr 16, 2024

Excel SUMIF function calculates the sum of a range of cells based on specified criteria. It allows the users to specify a range of cells to be ...

How to Use Excel SUMIF Function Based on Cell Color

How to Sum If Cell Contains Number in Excel (6 Examples)

Jul 19, 2024

Here we can see that the price of the Google Pixel 6 is in text format. We have calculated the total price including the price of the Google Pixel 6. ...

How to Sum If Cell Contains Number in Excel (6 Examples)

How to Sum If Cell Contains Number and Text in Excel

May 16, 2024

The following dataset contains sales records of the Continental Group for January. It includes information such as the date of the sale, the name and ...

How to Sum If Cell Contains Number and Text in Excel

How to Use the Excel SUMIF with Blank Cells (3 Methods)

Jul 26, 2024

Dataset Overview Let’s take a dataset where a charitable organization named Save the Poor has a list of donations. Here, in the Donor Name ...

How to Use the Excel SUMIF with Blank Cells (3 Methods)

How to Use the Excel SUMIFS with Not Equal to Text Criteria: 4 Examples

Jul 29, 2024

Dataset Overview In this tutorial, we’ll explore how to use the SUMIFS function to exclude specific values based on criteria. Let’s consider a ...

How to Use the Excel SUMIFS with Not Equal to Text Criteria: 4 Examples

Excel SUMIF Not Working (9 Possible Cases with Solutions)

Apr 30, 2024

This image depicts 3 reasons and their solutions when the SUMIF function is not working among the 9 reasons we will discuss in this article. You can ...

Excel SUMIF Not Working (9 Possible Cases with Solutions)

How to Use SUMIF Function to Sum Not Blank Cells in Excel: 5 Ways

May 22, 2024

Method 1 - Applying “Not Blank” Operator The Not Blank operator can be used to find out whether a cell or a range of cells is blank or not. The ...

How to Use SUMIF Function to Sum Not Blank Cells in Excel: 5 Ways

Excel VBA to Find Cell Address Based on Value (3 Examples)

Jul 7, 2024

The sample dataset contains the sales data of a certain showroom. Example 1 - Finding Only First Cell Address Based on Value By default, ...

Excel VBA to Find Cell Address Based on Value (3 Examples)

How to Use Excel SUMIF to Sum Values Greater Than 0 (3 Methods)

Jul 29, 2024

Introduction to the SUMIF Function in Excel Microsoft Excel includes a built-in function called SUMIF, which allows you to add up values within a ...

How to Use Excel SUMIF to Sum Values Greater Than 0 (3 Methods)

How to Use VLOOKUP Function with Exact Match in Excel

Jul 5, 2024

In this article, we'll describe four examples of how to use the VLOOKUP function with an exact match effectively. Here is the overview of the dataset ...

How to Use VLOOKUP Function with Exact Match in Excel

How to Use the LARGE Function with the VLOOKUP Function in Excel – 2 Methods

Aug 10, 2024

This is an overview. Method 1 - Combine the LARGE and the VLOOKUP Functions to Extract Associated Text Data in Excel The ...

How to Use the LARGE Function with the VLOOKUP Function in Excel – 2 Methods

How to Find Largest Number in Excel (2 Easy Ways)

Aug 4, 2024

We'll use a large dataset and determine the largest number from it. The image shows the overview of the functions we'll use. How to Find ...