Excel Functions Archives - Page 9 of 40

How to Use COUNTIFS Function with 3 Criteria in Excel

Jul 8, 2024

Here’s the sample dataset that we’ll use to demonstrate the examples. It represents some salespersons’ sales and dates in different ...

How to Use COUNTIFS Function with 3 Criteria in Excel

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

Nov 11, 2025

The COUNTIF function is used extensively to count values based on criteria. Using wildcards in the criteria makes the formula more dynamic. ...

[Fixed] COUNTIF Function with Wildcard Not Working in Excel

COUNTIF Function to Count Cells That Are Not Equal to Zero

Jun 16, 2024

Let's use the Sales Report of a particular grocery store. This dataset contains the names of the Sales Rep, the Product Name, and their respective ...

COUNTIF Function to Count Cells That Are Not Equal to Zero

How to Use Nested COUNTIF Function in Excel: 6 Suitable Methods

Jun 4, 2024

Method 1 - Nesting Two COUNTIF Functions Steps: Go to the D16 cell >> enter the formula given below. ...

How to Use Nested COUNTIF Function in Excel: 6 Suitable Methods

Excel VLOOKUP Returning Column Header Instead of Value

Jul 16, 2024

Reason 1 - The Dataset and Columns Are Not Correctly Organized The first reason that contributes to returning column header instead of value is the ...

Excel VLOOKUP Returning Column Header Instead of Value

How to Differentiate Between SUMIF and COUNTIF Functions in Excel (2 Examples)

Jul 15, 2024

Dataset Overview We will use the following sample dataset to illustrate the differences: Example 1 - Difference in Function Argument ...

How to Differentiate Between SUMIF and COUNTIF Functions in Excel (2 Examples)

How to Compare Two Columns Using COUNTIF Function: 4 Methods

Jul 6, 2024

Method 1 - Use Only COUNTIF Function to Compare Two Columns in Excel Steps: Type the following formula in Cell E5- =COUNTIF($C$5:$C$11,D5) ...

How to Compare Two Columns Using COUNTIF Function: 4 Methods

How to Use COUNTIF Function in Excel Greater Than Percentage

Aug 4, 2024

This tutorial will demonstrate how to use the COUNTIF function to find the number of values greater than a percentage in Excel. Step 1 - ...

How to Use COUNTIF Function in Excel Greater Than Percentage

How to Use COUNTIF to Count Date Less Than Today in Excel

Nov 11, 2025

If you are looking for Excel countif date less than today, you have come to the right place. Here, we will walk you through 3 easy and effective ...

How to Use COUNTIF to Count Date Less Than Today in Excel

[Fixed!] Excel COUNTIF Function Not Working for String “True”

Nov 11, 2025

The COUNTIF function is one of the most useful functions in Excel. It is used to count values if the function is true for the given criteria. But ...

[Fixed!] Excel COUNTIF Function Not Working for String “True”

Excel VLOOKUP is Not Working with Numbers – 2 Solutions

Aug 8, 2024

This is the sample dataset. The table on the left showcases Student Ids and their Marks. The table on the right contains Names, Student IDs ...

Excel VLOOKUP is Not Working with Numbers – 2 Solutions

[Fixed!]: VLOOKUP Function Is Returning Same Value in Excel

Nov 11, 2025

The VLOOKUP function is widely used for importing data from a worksheet or workbook. However, due to the function’s argument issue, this function ...

[Fixed!]: VLOOKUP Function Is Returning Same Value in Excel

[Fixed!] Excel VLOOKUP Not Working Due to Format (2 Solutions)

Jun 17, 2024

The sample dataset contains information from a store with the items’ codes, names, and sales. Due to format errors, the VLOOKUP ...

[Fixed!] Excel VLOOKUP Not Working Due to Format (2 Solutions)

The Excel VLOOKUP Function is Returning 0 Instead of the Expected Value – Possible Solutions

Aug 15, 2024

The following VLOOKUP function returned 0 although the matching result is an empty cell. =VLOOKUP(E5,B5:C12,2,FALSE) Step ...

The Excel VLOOKUP Function is Returning 0 Instead of the Expected Value – Possible Solutions

The VLOOKUP is Not Working Between Sheets – 8 Easy Solutions

Aug 4, 2024

This is the Source sheet from which you will extract data. Solution 1- Entering the Correct Lookup Value, the Worksheet Name, and the ...