Archive for August 2013

Excel Hlookup Formula

Learn How to use Excel Hlookup Formula: In Excel HLOOKUP formula, H stands for Horizontal and LOOKUP means lookup. Hlookup is used to lookup values in a data table where lookup_value resides. Lets see Hlookup syntax and an example to… Read More ›

Excel Vlookup Formula

Learn How to use Excel Vlookup Formula: In Excel VLOOKUP formula, V stands for Vertical and LOOKUP means lookup. Vlookup is used to lookup values in a data table where lookup_value resides. Lets see Vlookup syntax and an example to… Read More ›

Excel Averageifs Formula

Learn how to use Excel Averageifs Formulas: Excel Averageifs Formula averages a Set of values IF(S) a single or multiple conditions are met. In other words, averageifs function averages the number of cells that met one or more than one… Read More ›

Excel Averageif Formula

Learn how to use Excel Averageif Formula: Excel Averageif Formula AVERAGE the data value IF it meets specified criteria or condition. Lets understand this with the help of Averageif Formula syntax and an example. Averageif Function Syntax: Averageif(range, criteria, [average_range])… Read More ›

Excel Sumifs Formula

Learn how to use Excel Sumifs Formula: Excel Sumifs Formula sum a Set of values IF(S) a single or multiple conditions are met. In other words, sumifs function count number of cells that met one or more than one condition…. Read More ›

Excel Countifs Formula

Learn how to use Excel Countifs Formula: Excel Countifs Formula COUNT number of cells IF(S) a single or multiple conditions are met. In other words, Countifs Function count number of cells that meet one or more than one condition. Countifs… Read More ›

Excel Countif Formula

Learn how to use Excel Countif Formula: Excel COUNTIF Formula COUNT number of Cells IF a given criteria is meet. In other words, Countif Function count number of cells that have an item in a list. Make a note that… Read More ›

Excel Sumif Formula

Learn how to use Excel Sumif Formula: Excel Sumif Formula adds the data value that meets specified criteria or condition. Lets understand this with the help of Sumif Formula syntax and an example. Sumif Function Syntax: Sumif(range,criteria,[sum_range]) Range: The range… Read More ›

Excel Isnumber Formula

Learn how to use Excel Isnumber Formula: Excel Isnumber formula test if a cell has number or not. It returns True if the value in cell is number, otherwise False. For Example, 123 is a number and Isnumber Formula will… Read More ›

Excel Istext Formula

Learn how to use Excel Istext Formula: Excel Istext formula test if a cell has text or not. It returns True if the value in cell is Text, otherwise False. For Example, “ABC” is a text and Istext Formula will… Read More ›