How to use VLOOKUP in excel

VLOOKUP in excel is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the  given column (col_index_num) of the matching row. The syntax for VLOOKUP in excel: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value  is the value you want to search in a table or array.This can be text, number or logical vaues and are not case sensetive. table_array: this is…

Continue Reading

SUMIFS Functions in Excel

SUMIF function is used to add the cells in a range which meets the given criteria. In SUMIF function you can give only one criteria. SUMIFS function adds the cells in a range which meets multiple criteria. Syntax for SUMIFS function is=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)The sequence of arguments are different in SUMIFS function as compare to SUMIF.sum_range argument is the first argument in the SUMIFS function. This is the range of cells the value of which is to…

Continue Reading

How to use Excel SUMIF Formula

In this article we have explained how to use Excel SUMIF Formula.Excel SUMIF function can be used to sum the value in a range that meets the given criteria.  Syntax for Excel SUMIF Formula is: =SUMIF(range, criteria,[sum_range])range is the argument that specifies the cells in which the criteria or the condition is to be checked. We should select the range of cells in the formula.criteria is the condition to be checked, which can be text, number, cell reference, formula etc. The criteria…

Continue Reading

Excel SUM Formula

SUM is one of the most commonly used function in Excel , which is used to add the numbers in the argument. In this article you can learn the syntax and how to use excel SUM formula. You can use this formula to add the numbers in a range by selecting a range reference in the formula.   You can also use select the cell references to add the required cells by separating the cell reference with comma( , ).…

Continue Reading

How to use $ sign in formula – relative and absolute references in excel

In excel formula the reference can be given to different cell. The reference is just like giving address of the cell. The formula will take the value of the cell mentioned in the reference. The reference can be relative reference or absolute reference. In this article i will explain how to use relative and absolute references in excel. Cell Address in Excel There are two different formats to refer the address of the cell in excel.  Columns are identified with…

Continue Reading

ISERROR and IFERROR excel functions to handle error value

In Microsoft Excel, if the inputs are not valid, then the formula will show the error. This error may be like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. To avoid this error, you can use the "ISERROR" or "IFERROR" formula. "IFERROR" is simple and easy, but this function is available only in Excel 2007 and above versions.   In this post you can learn how to use these two functions to handle the error in excel formula. If you…

Continue Reading
Close Menu