Excel Functions

How to Use CONCAT Function in Excel

In this article, we have talked about how to use the CONCAT function in Excel. We have demonstrated various examples of using the CONCAT function ...

How to Use VBA Array Function in Excel

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 Function for Not Equal Criteria

In this article, we will know how to use Excel SUMIF not equal criteria. Excel's SUMIF function is a strong tool for computing sums based on ...

Sum If Greater Than and Less Than Cell Value in Excel

In Excel, you may apply multiple conditions to sum values. From them, the greater than and less than condition is mostly used. You can use both ...

How to Use SUMIF to SUM Less Than 0 in Excel (3 Easy Ways)

In this article, we will illustrate how to use the Excel SUMIF function to sum values less than 0. Profit and loss are highly related to business. ...

How to Use Excel SUMIF with Greater Than Criterion

In this modern world, life without Excel is kind of unimaginable. Almost in every working sector, Excel works as an essential tool. Numerous ...

How to Use Excel SUMIF Function Based on Cell Color

Are you tired of manually sorting data in Excel to find and add up values based on cell color? Look no further than the Excel SUMIF function. This ...

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

Sometimes, we need to sum if a cell contains a number in Excel. We need to do this very often in data analysis and financial modeling. Sometimes the ...

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

How to Sum If Cell Contains Number and Text in Excel

It is an informative article that provides solutions to a common problem encountered by Microsoft Excel users. This article discusses the challenge ...

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

This article illustrates how to use the SUMIF function to sum up values corresponding to blank or empty cells in Excel. Even though blank cells are ...

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

Excel SUMIFS with Not Equal to Text Criteria (4 Examples)

In this article, we are going to discuss how to use the Excel SUMIFS function with Not Equal to Text criteria. Excel users often need to sum specific ...

Excel SUMIF Not Working (9 Possible Cases with Solutions)

With the help of Excel's SUMIF function, users can sum a range of numbers in accordance with specific criteria. However, there are times when the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo