Function: AVERAGEIF

Function: AVERAGEIF

AVERAGEIF function takes the average of the values in a range of cells that match a criteria. In this guide, we’re going to show you how to use the AVERAGEIF function and also go over some tips and error handling methods.Supported versionsAll Excel...

Function: COUNTIF

Function: COUNTIF

COUNTIF counts the values in a range of cells that match a given criteria. In this guide, we’re going to show you how to use the COUNTIF function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax[box...

Function: SUMIF

SUMIF function can sum up the values in a range of cells that match a single criteria. In this guide, we’re going to show you how to use the SUMIF function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax[box...

Function: SEARCH

Function: SEARCH

Excel SEARCH function returns an integer that represents the position of a specified character or substring within a text. In this guide, we’re going to show you how to use the Excel SEARCH function and also go over some tips and error handling...

Function: FIND

Function: FIND

Excel FIND function returns an integer that represents the position of a specified character or substring, within a text. In this guide, we’re going to show you how to use Excel FIND function, and also go over some tips and error handling methods.Supported...

Function: MID

Function: MID

The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods.Supported versionsAll Excel...

Function: RIGHT

Function: RIGHT

The RIGHT function returns a sub-string from a specified string, starting from the right-most character. In this guide, we’re going to show you how to use the Excel RIGHT function and also go over some tips and error handling methods.Supported versionsAll...

Function: LEFT

Function: LEFT

The LEFT function returns a sub-string from a specified string, starting from the left-most character. In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods.Supported versionsAll...

Function: DATEVALUE

Function: DATEVALUE

Excel DATEVALUE function returns a date serial number from a specified date that is stored as text. This function comes in handy when your dates are stored as text data, instead of Excel's date number format. In this guide, we’re going to show you how to use the...