## The COUNT Function: Syntax and Examples

The COUNT is an Excel statistical function that counts how many numbers are in a list of arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: If you want to count logical values, text, or error values, use the COUNTA function. And for numbers that meet a… Read more The COUNT Function: Syntax and Examples

## The AVERAGE Function: Syntax and Examples

The AVERAGE is an Excel statistical function that calculates the average of its arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: the AVERAGE will calculate the arithmetic average (adds up all the arguments and divides it with their count). If you need a median,… Read more The AVERAGE Function: Syntax and Examples

## The PROPER Function: Syntax and Examples

The PROPER is an Excel text function that capitalizes the first letter in each word of a text value. Syntax PROPER(text) Required Arguments text: Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize Proper Function Examples This function can be… Read more The PROPER Function: Syntax and Examples

## The MAX Function: Syntax and Examples

The MAX is an Excel statistical function that returns the largest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MAXA function.… Read more The MAX Function: Syntax and Examples

## The MIN Function: Syntax and Examples

The MIN is an Excel statistical function that returns the smallest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MINA function.… Read more The MIN Function: Syntax and Examples

## The SUM Function: Syntax and Examples

The SUM is an Excel math and trigonometry function that adds values together. It is one of the oldest Excel functions, so it can be used even with Excel 2003. SUM Syntax Required Arguments number1: This is the first number that you want to add. It can be a number, a cell reference or a… Read more The SUM Function: Syntax and Examples

## The RAND Function: Syntax and Examples

The RAND is an Excel math and trigonometry function that returns a random value between 0 and 1. Excel uses the Mersenne Twister algorithm for this. It is one of the oldest Excel functions, so it can be used even with Excel 2003. RAND Syntax Required Arguments The RAND function does not take any arguments.… Read more The RAND Function: Syntax and Examples

## 8 Most Common VLOOKUP Errors

Excel’s VLOOKUP function is a powerful and helpful function that can help filter your data down to a desired item. It is sort of a combination of database functionality and search engine ease to refine your spreadsheet’s content to some given search item. However, VLOOKUP for all of its powerful abilities can sometimes be frustratingly… Read more 8 Most Common VLOOKUP Errors

## Excel XIRR Function Examples

Excel function XIRR is a financial function which returns the internal rate of return for a series of cash flows, occurring at irregular period intervals. The XIRR function includes an initial investment and net income values. This function is derived from the IRR function which does the same calculation but works only with regular (equal)… Read more Excel XIRR Function Examples