Excel Functions

[Fixed!] Excel EXACT Function Not Working (3 Suitable Solutions)

One of the many functions available in Excel is the EXACT function, which allows users to compare two text strings and determine if they are ...

Use of PERMUTATIONA Function in Excel (4 Simple Examples)

In this article, we will explore how to use the PERMUTATIONA function in Excel to generate phone numbers, pin codes, license plate numbers, and even ...

How to Use EVEN Function in Excel (5 Examples)

The EVEN function in Excel is a tool that can round up a number to the nearest even integer. It takes one argument, which is the number you want to ...

Advanced VLOOKUP in Excel

Advanced VLOOKUP in Excel: Knowledge Hub Use VLOOKUP for Multiple Columns VLOOKUP from Multiple Columns with Only One Return Use VLOOKUP ...

How to Sum If Cell Contains Number and Text in Excel

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 Use the Excel SUMIF with Blank Cells (3 Methods)

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

[Fixed!] Excel SUMIF with Wildcard Not Working (4 Solutions)

This article will discuss 4 possible solutions for Excel SUMIF not working with a wildcard. The SUMIF function often fails to recognize wildcard ...

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

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

Excel SUMIF Not Working (9 Possible Cases with Solutions)

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

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

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

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

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

How to Use DSTDEVP Function in Excel (2 Suitable Examples)

Are you looking for an Excel function that will return the standard deviation of the entire population and also match the given criteria? In this ...

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

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 VLOOKUP Function with Exact Match in Excel

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 Excel DMAX Function (2 Easy Examples)

Excel is a powerful software as it has predefined functions and numerous features. These functions make the excel experience smoother and more ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo