Excel Functions

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

In this article, we will learn in detail about table array in Excel including using, and applying variables, with defined names, from another ...

Excel LOOKUP and Reference Functions

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

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

IF with ISERROR Function in Excel: 4 Practical Examples

In this article, we are going to explore the combination of IF with the ISERROR function in Excel in different circumstances, such as finding unit ...

Excel Function Categories

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

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

VLOOKUP Between Worksheets in Excel

VLOOKUP Between Worksheets in Excel: Knowledge Hub VLOOKUP and SUM Across Multiple Sheets VLOOKUP Example Between Two Sheets Perform ...

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

Excel SUMIF with Date Range (Complete Guideline)

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo