# Category: Functions

### VLOOKUP function

Posted by John | Apr 30, 2016 | Lookup and Reference | 0 |

## The Ultimate Guide To VLOOKUP

The VLOOKUP function allows you to search a value in the left most column of a range and return the corresponding value in a column to the right. The search is vertical from top to bottom and in fact, the “**V**” in **VLOOKUP** stands for **vertical**.

## COUNTIFS function

This function will conditionally count items in a range based on given criteria. Syntax COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2,…) Range 1 (required) – This is the range to which the first criteria is...

Read More## INT function

This function will rounds a number down to the nearest integer. Syntax INT(Number) Number (required) – This is the number you want to round down to the nearest integer. Example In this example find the round down a few...

Read More## SUMIFS function

This function will conditionally sum up numbers in a range based on given criteria. Syntax SUMIFS(Sum Range, Range 1, Criteria 1, Range 2, Criteria 2,…) Sum Range (required) – This is the range of numbers to sum....

Read More## ABS function

This function will return the absolute value of a number. The absolute value is the “positive” part of a number. Syntax ABS(Number) Number (required) – This is the number you want to find the absolute value of....

Read More## PROPER function

This function will function will capitalize the first letter of each word. Syntax PROPER(Text) Text (required) – This is the text string which you want to capitalize the first letter of each word. Example In this example...

Read More