Excel Functions Archives - Page 12 of 40

Excel COUNTIFS Function with Multiple Criteria in Same Column

Nov 11, 2025

Looking for ways to know how to use the COUNTIFS function in Excel with multiple criteria in the same column? We can count values, texts or dates ...

Excel COUNTIFS Function with Multiple Criteria in Same Column

How to use the Excel VLOOKUP Function for a Partial Match in a Table Array – 3 Examples

Aug 15, 2024

Example 1 - Using Wildcards in the VLOOKUP Function to Look up a Partially Matched Text Steps: Prepare the dataset: assign cells to insert the ...

How to use the Excel VLOOKUP Function for a Partial Match in a Table Array – 3 Examples

Example of Cell Address in Excel (5 Ideal Cases)

Nov 11, 2025

When working with Excel, it is a must to know clearly about cell addresses. Because, when you insert or extract formulas, the cells are the most ...

Example of Cell Address in Excel (5 Ideal Cases)

Excel COUNTIFS Not Working with Multiple Criteria (2 Solutions)

Nov 11, 2025

This article highlights the possible reasons behind and solutions for the COUNTIFS function in Excel not working with multiple criteria. If you need ...

Excel COUNTIFS Not Working with Multiple Criteria (2 Solutions)

How to Use the VLOOKUP Function with Multiple Criteria in Different Sheets – 4 Methods

Aug 11, 2024

The sample dataset is an overview. Method 1 - Using in VLOOKUP Function on Each Sheet Individually Steps: Create a dataset as shown ...

How to Use the VLOOKUP Function with Multiple Criteria in Different Sheets – 4 Methods

How to Use VLOOKUP with Multiple Criteria in Different Columns

Nov 11, 2025

Whilst working in Microsoft Excel, we’ve all faced a scenario where we need to look up a value from a dataset based on a few criteria. Now, even with ...

How to Use VLOOKUP with Multiple Criteria in Different Columns

How to Get Cell Value by Address in Excel: 6 Simple Methods

Jul 7, 2024

Method 1 - Get Cell Value Using ADDRESS Function Steps: Go to cell D4 and insert the following formula: =INDIRECT(ADDRESS(10,2)) ...

How to Get Cell Value by Address in Excel: 6 Simple Methods

[Fixed!] Excel VLOOKUP Partial Match Not Working

Nov 11, 2025

One of the most powerful functions in Excel is the VLOOKUP function. It helps to find any specific data or value from a large dataset. Even it works ...

[Fixed!] Excel VLOOKUP Partial Match Not Working

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way: 5 Methods

Jul 4, 2024

Method 1 - Use a Helper Column to Left to Match Multiple Criteria with VLOOKUP Steps: Create a helper column on the left side of your dataset. ...

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way: 5 Methods

Using the Excel COUNTIFS Function with Multiple Criteria and the OR Logic – 3 Examples

Aug 12, 2024

The sample dataset contains information about Products, their Payment Status and Quantity. To count the number of laptops and keyboards with ...

Using the Excel COUNTIFS Function with Multiple Criteria and the OR Logic – 3 Examples

Using the Excel COUNTIF Function with Multiple Criteria and a Date Range – 6 Examples

Aug 9, 2024

This is the sample dataset. Example 1 - Counting the Number of Different Dates Using the COUNTIF Function with a Multiple ...

Using the Excel COUNTIF Function with Multiple Criteria and a Date Range – 6 Examples

How to Use COUNTIFS with Date Range and Text in Excel

Nov 11, 2025

In this tutorial, I am going to show you 4 practical examples of how to use COUNTIFS with date range and text in Excel. You can quickly use these ...

Vlookup with Time Range in Excel (5 Easy Ways)

Jun 30, 2024

In this article, we will demonstrate five quick methods to VLOOKUP within a time range in Excel. To demonstrate the methods, we'll use the dataset ...

Vlookup with Time Range in Excel (5 Easy Ways)

How to Edit Table Array in Excel (2 Suitable Ways)

Nov 11, 2025

Sometimes we use a table array formula in Excel and after that, we need to edit it. Editing an array formula is different than editing a normal Excel ...

How to Edit Table Array in Excel (2 Suitable Ways)

How to Expand Table Array in Excel (5 Simple Ways)

Nov 11, 2025

If you want to expand a table array in Excel, then this article will be helpful for you. The main objective of this article is to explain how to ...