## Excel COUNTIFS Function – How to Use (with example)

This tutorial describes the formula syntax and usage of the Excel COUNTIFS Function and its usages. Definition – Excel COUNTIFS Function   Excel COUNTIFS function is a member of COUNT family in Microsoft Excel and advanced version of Excel COUNTIF Function. Excel COUNTIFS function count the number of cells in a data-set or range with a …

## Excel COUNTIF Function With Multiple Criteria

Excel COUNTIF function Excel COUNTIF function is the combination of COUNT and IF function.   Excel COUNTIF function – How to define “Excel COUNTIF  function helps us to find a result in a range of cells or dataset if there is any condition or criteria is provided.” Syntax of Excel COUNTIF function =COUNTIF (range, criteria) range …

## Excel COUNTBLANK Function – How to Use (with example)

This tutorial describes the formula syntax and usage of the Excel COUNTBLANK Function and its usages. Definition of Excel COUNTBLANK Function Excel COUNTBLANK Function is a part of COUNT family in Microsoft Excel. We apply this function to retrieve or count all the blank cells in a range of cells. It Returns a Value Excel …

## Excel COUNTA Function – How to Use (with example)

This tutorial describes the formula syntax and usage of the COUNTA function and its usages. Excel COUNTA Function – How to Define Excel COUNTA function is a part of COUNT family in Microsoft Excel. We apply this function to retrieve the total count of cells. Which has any kind of data or values in a …

## Excel COUNT Function – How to Use (with example)

In this post, we will learn about Excel COUNT Function with examples. Excel COUNT Function – Definition     Excel COUNT function is a built-in function of Microsoft Excel and its feature are as follows:-   This function counts only numeric values in a cell or a range of cells. And skips the text values …

## How to use Excel SEARCH function with example

In this post, we will learn about Excel SEARCH function. Excel SEARCH function seeks the location of a character in a string.  And returns its position number in the string from the starting character.   Excel SEARCH function is very similar function to the Excel FIND function. The only difference between both of the …

## How to use Excel FIND function with example

In this tutorial, we will learn about Excel FIND function. Excel FIND function seeks the location of a character in a string.  And returns its position in the string from the starting character.   How to define Excel FIND function   “Excel FIND function seeks the position of a character or sub-string within a …

## How to use Excel MID function (with example)

In this blog, we are going to learn about Excel MID Function. In earlier two blogs we have learned about Excel LEFT Function and Excel RIGHT function. Excel MID Function is very similar to these function but a little bit different. Excel MID Function has three parameters and all are required to retrieve the …

## How to use Excel RIGHT function with example

Excel RIGHT function In this blog post, we will learn about Excel RIGHT function. What is Excel RIGHT Function and how can we use this function in our working routine. This function is very similar to Excel LEFT function. The only difference is the Excel LEFT Function retrieves the data from the left side of …

## How to use Excel LEFT Function with example

In this blog post, we will learn about Excel LEFT function. What is Excel LEFT Function and how can we use this function in our working routine? Define Excel LEFT function “Excel LEFT function helps us to retrieve some specific numbers of characters from the given string in a cell.” Excel LEFT Function   …