SUMPRODUCT with Criteria in 2 Columns in Microsoft Excel 2010

In this article, we will focus on how to use SUMPRODUCT function with criteria in 2 columns & extract the output, meeting all the conditions. Q...

Nested IF statement in Microsoft Excel

In case you want to learn Excel IF function then this article is for you. In this article, we will focus on describing the use of IF function in multi...

Reverse Vlookup in Microsoft Excel

If you are wondering how you can make Vlookup work backwards then this article is for you. In this article, we will learn how to use reverse Vlookup f...

AVERAGEIFS, SUMIFS and COUNTIFS Functions in Microsoft Excel

In this article, we will learn how to apply “Averageifs”, “Sumifs” and “Countifs” in Microsoft Excel 2013. AVERAGEIFS: Finds average (a...

How to Use Wildcard with Vlookup in Microsoft Excel

In case you have not use Vlookup with wildcard then this article is for you & you will really wonder how easy your life would be after you learn t...

Left Function in Microsoft Excel

In this article, we’ll learn how we can use LEFT function in Microsoft Excel. In Microsoft Excel, LEFT function is used to extract the leftmost cha...

Highlight Duplicates in Excel

How to find duplicate in Excel by using Conditional Formatting? In this article, we will learn how to find duplicates and more in Microsoft Excel 2...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube