Vlookup Return Custom Value

Overview  Return custom value in VLookup of Excel is an article that will help you understand how you can return a custom value when your VLookup succeeds.  Good to know  This exercise for returning a custom value in VLookup requires you to know the IF function, nested functions, and a basic understanding of how to […]

Google Sheets – Sum, Average, Min & Max

In this article of Google Sheets – Sum Average Minimum & Maximum, we will discuss how to find sum and average from a given set of data, and we will also show you how to find the smallest and the largest number from the same set of data. By the end of this tutorial, you […]

How to use Excel Count Functions

Excel Count Functions

Overview of Excel Functions Excel count functions or very handy and help you in a great way to deal with their assets when it comes to Counting stuff inside Excel. In this article, we are going to talk about five different count functions of Excel.  Types of Count Functions in Excel Excel COUNT Excel COUNTA […]