## The SUMIFS Function in Excel

The Excel SUMIFS function is used if you need to apply multiple criteria to get the sum of range.

Demos and Full Guide

## Counting Characters in Excel

For counting the number of characters in single or multiple cells, you may use the Excel LEN function. In the LEN function, you may provide a text string, cell or use LEN with SUM function for counting characters.

Demos and Full Guide

## Functions to get substrings in Excel

The Excel has a few functions like LEFT, MID, and RIGHT that can be used for getting the substrings from the given text, specified cell etc.

Demos and Full Guide

## Excel TRIM function for removing spaces

Whether text is based on external sources or written within Excel, you may remove the spaces on left and right of the text by using the TRIM function.

Demos and Full Guide

## What is SUMIF function in Excel?

If you require sum of a range with certain condition then use the SUMIF function. If you separate SUM + IF, it already makes you understand why we use that.

Demos and Full Guide

## The INDEX function in Excel

The Excel INDEX function requires the position and range and returns the value based on that position. If you do not know the position, you may get this by using MATCH function.

Demos and Full Guide

## Excel Dropdown List

In this tutorial, I will show you how to make dropdown list in Excel with examples. Not only will I show you ways of how to create dropdown but how to use its values in different formulas as well.

Demos and Full Guide

## The MROUND function for rounding nearest to 5, 10, 100, 1000 etc.

For getting the nearest multiple for any number like 5, 10, 100 etc. you may use the MROUND function in Excel. The MROUND function takes two arguments: MROUND(number, multiple)

Demos and Full Guide

## Excel Subtract Date Formulas

There is a number of ways for calculating the difference between two dates in Excel. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates.

Demos and Full Guide

## The functions to replace text in Excel

The Excel REPLACE and SUBSTITUTE functions can be used for replacing new text string by existing text in the given text. See the examples, syntax, and difference between these two functions by this tutorial.

Demos and Full Guide

## How to round numbers in Excel?

The Excel has a number of functions that enable rounding the decimal numbers as per the need. These functions are: ROUND
ROUNDUP, ROUNDDOWN and MROUND

Demos and Full Guide

## HLOOKUP Function in Excel

The Horizontal lookup function, HLOOKUP in excel is used to find the specific value in a row for the table that is arranged horizontally.

Demos and Full Guide

## 4 Ways of How to Calculate Age in Excel (Years, Months and Days)

Formulas to Calculate Age in Excel In Excel, you may calculate the age in a number of ways. It is up to your choice and requirements that which way to use. For example, you may just require the age in…

Demos and Full Guide

## The DATEDIF Function in Excel

The Excel DATEDIF function takes the start date, end date, unit and calculates the difference in terms of days, months or years between these two dates. The unit specifies what you require; days, month, or years.

Demos and Full Guide

## What are Excel FIND and SEARCH functions?

The FIND is case sensitive to return the position. The ‘C’ and ‘c’ has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the ‘*’ and ‘?’ wildcards in the FIND function.

Demos and Full Guide