Excel Functions Archives - Page 2 of 40

Excel Sum with VLOOKUP

Nov 11, 2025

Excel Sum with VLOOKUP: Knowledge Hub How to Sum All Matches with VLOOKUP in Excel Use VLOOKUP to Sum Multiple Rows in Excel How to ...

Table Array in Excel (Create, Use and Fix Issues)

Jul 6, 2024

The table below is an overview of table array to lookup values in Excel. Download Practice Workbook Table Array.xlsx What Is ...

Table Array in Excel (Create, Use and Fix Issues)

Excel LOOKUP and Reference Functions

Nov 11, 2025

Excel LOOKUP and Reference Functions: VLOOKUP Advanced Excel Lookup Functions HLOOKUP XLOOKUP LOOKUP INDEX MATCH ADDRESS ...

How to Use the CONCAT Function in Excel – 7 Examples

Aug 3, 2024

Quick View: Download Practice Workbook CONCAT Function.xlsm Overview of the CONCAT Function Syntax: =CONCAT(Text1, …) ...

How to Use the CONCAT Function in Excel – 7 Examples

IF with ISERROR Function in Excel: 4 Practical Examples

Jul 8, 2024

Here's an overview of using the IF and ISERROR functions to check a car's unit price depending on the amount of available stock. What Is ...

IF with ISERROR Function in Excel: 4 Practical Examples

Excel Function Categories

Nov 11, 2025

Excel Function Categories: Knowledge Hub Excel LOOKUP and Reference Functions Excel Date Functions Use of Excel Database Functions DGET, ...

How to Use VBA Array Function in Excel

Nov 11, 2025

The Array Function is a very useful tool in Excel to store data and limit the use of the variable, which is basically saving a lot of memory usage of ...

Excel SUMIF Not Equal Criteria: 5 Suitable Examples

May 29, 2024

Method 1 - Calculating Sum with Numeric Not Equal Single Criteria Use the following formula in a cell of your worksheet. =SUMIF(E5:E17, ...

Excel SUMIF Not Equal Criteria: 5 Suitable Examples

Sum If Greater Than and Less Than Cell Value in Excel

May 21, 2024

Method 1 - Sum If Greater Than and Less Than from Same Value 1.1 Applying SUMIF Function for Greater Than and Less Than from Same Value You have to ...

Sum If Greater Than and Less Than Cell Value in Excel

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

Excel SUMIF with Date Range (Complete Guideline)

Nov 11, 2025

In this article, we will demonstrate the use of the SUMIF function with date range in Excel. In this section, we will look at how to use the SUMIF ...

Excel SUMIF with Date Range (Complete Guideline)

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. ...